How to reference same column name but different table in custom db query

Question

I use wpdb to connect to a custom db, then I use the following query:

$my_row = $wpdb_c->get_results("SELECT Employee.Name, Area.Name, Area.Region FROM Area INNER JOIN Employee ON Area.ID = Employee.Area_ID WHERE Employee.ID = " . get_the_ID());

How do i refer to each of the Name columns from the Employee and Area tables? I tried $my_row[0]->Area.Name but it only returned the string 'Name'.

Answer 1

Modify your query and use tha SQL alias as

$my_row = $wpdb_c->get_results("SELECT Employee.Name as Employe_Name, Area.Name as 
Area_Name, Area.Region as Area_Region FROM Area INNER JOIN Employee ON Area.ID = 
Employee.Area_ID WHERE Employee.ID = " . get_the_ID());

then in your code use

$my_row[0]->Area_Name