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

Modify your query and use the 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

Related Posts:

  1. Differences between wpdb->get_results() and wpdb->query()
  2. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  3. wpdb get posts by taxonomy SQL
  4. Multipart/formatted MySQL query problem
  5. Custom $wpdb Query for Custom Post Type by Category
  6. Can’t pass table to $wpdb->prepare
  7. $wpdb->get_var not returning a result
  8. Most effective use of DB querys
  9. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  10. wpdb::prepare() isn’t working
  11. $wpdb doesn’t appear to work on page inside of a plugin
  12. Strange string in console from wpdb query
  13. Using $wpdb->update but confused on the WHERE in and SET
  14. What’s wrong with my $wpdb prepare?
  15. Make one query for adding entries to database
  16. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  17. Alter a specific query on WordPress
  18. wpdb->term_taxonomy count posts from both published and private posts?
  19. wpdb print all post meta
  20. Plugin will sort users by usermeta
  21. wpdb query problem to access previous 3 days posts
  22. How to write: $wpdb->update having WHERE NOT value pair in the array
  23. I can’t figure out what’s wrong with this statement. $wpdb->query update
  24. Use mysql_query instead of $wpdb query
  25. wpdb COALESCE won’t work
  26. Custom Query – Based on user input
  27. Custom SQL Query passing array to WHERE p.id
  28. Get posts from category with custom query
  29. Custom Query returns array, but I can’t see it’s elements
  30. Valid SQL query return empty
  31. mysql query – how to escape apostrophe?
  32. $wpdb->prepare affecting the query?
  33. prepare function sql safe method
  34. Updating with $qpdb->query() always returns 0 rows affected
  35. How to return count of custom post type posts with a specific custom field value via $wpdb?
  36. WordPress Mysql query and Duplicate
  37. How do I query for posts by custom meta and those that have been stickied?
  38. Help with Related Posts Function
  39. wpdb update multiple row?
  40. Formatting a date/time returned from a custom $wpdb query
  41. Improve performance of slow query
  42. How do I get specific readable results from this query and array results
  43. implementing my wp_query using $wpdb class
  44. Exclude Posts from a Widget
  45. Fastest and most efficient SQL query to check if UID exists
  46. Use $wpdb->get_results with filter based on array
  47. $wpdb query for price in custom field value
  48. Display result from custom post meta query
  49. Wpdb empty result only if language is Russian
  50. Run an update query in a function
  51. How to fix this insert? Don’t work for me!
  52. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  53. Update vs Insert logic but the last key is always inserted?
  54. There is way to improve this query? wordpress get post data and some meta data
  55. $wpdb: how to use a query as a base for another query?
  56. Wpdb generates too many queries
  57. Custom Query for searching through custom fields
  58. Mysql query and odd results
  59. Retrieving custom field array value through db query
  60. How to get one result using wpdb class?
  61. Delete query won’t run
  62. update $wpdb one query
  63. get_results using wpdb
  64. Add multiple value to a query variable in WordPress
  65. wp_dropdown_categories with multiple select
  66. How to get my loop to pull posts into three columns
  67. Date query year and month OR just year
  68. Are database queries created using WordPress filters protected from SQL injection?
  69. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  70. How to check current user in meta value array in WP_Query meta_query
  71. Change media attachment author via mysql query
  72. Optimizing Query used for a Shortcode
  73. $wpdb->replace: WHERE?
  74. Attempt to improve WP search, can someone check my SQL query?
  75. WordPress Query orderby title with UTF8 string in title
  76. Searching With Apostrophe
  77. get_posts showing only 5 posts. (nopaging and posts_per_page -1 not working)
  78. Custom WordPress Table wpdb
  79. Order by title – but now built in wordpress func, sort the_title
  80. Display posts between two particular dates
  81. Order posts by date, but also give priority for a specific term
  82. $post->ID not working in combination with a custom query
  83. Custom select query two tables by a meta key
  84. wpdb query with dynamic column name?
  85. How do you display the number of a post in a query?
  86. How can I get the name of term post meta value which equals term id
  87. Trying to use WP_Query to return post with and without meta values
  88. get products by custom date variable
  89. How to sort by two meta keys in admin area?
  90. How to get inserted row IDs for bulk/batch insert with wpdb query?
  91. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  92. SQL query to delete users with multiple meta keys and comments
  93. Nested select statements not working
  94. Pagination adds search query (again)
  95. Counting And Monitoring How Much Queries My Script Used
  96. wpdb get_results() returns only 2 rows
  97. Function returning queried meta value based on current post ID
  98. search.php is not generating the right results
  99. Slow query when joining wp_posts with a lookup-table?
  100. Using wp_list_table how to trigger update function “inline”?
tech