1052: Column ‘id’ in field list is ambiguous

SQL supports qualifying a column by prefixing the reference with either the full table name:

SELECT tbl_names.id, tbl_section.id, name, section
  FROM tbl_names
  JOIN tbl_section ON tbl_section.id = tbl_names.id

…or a table alias:

SELECT n.id, s.id, n.name, s.section
  FROM tbl_names n
  JOIN tbl_section s ON s.id = n.id

The table alias is the recommended approach — why type more than you have to?

Why Do These Queries Look Different?

Secondly, my answers use ANSI-92 JOIN syntax (yours is ANSI-89). While they perform the same, ANSI-89 syntax does not support OUTER joins (RIGHT, LEFT, FULL). ANSI-89 syntax should be considered deprecated, there are many on SO who will not vote for ANSI-89 syntax to reinforce that. For more information, see this question.

Related Posts:

  1. 1052: Column ‘id’ in field list is ambiguous
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  5. How do I restore a dump file from mysqldump?
  6. difference between primary key and unique key
  7. How to do a batch insert in MySQL
  8. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  9. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  10. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  11. How can I do a FULL OUTER JOIN in MySQL?
  12. Cannot delete or update a parent row: a foreign key constraint fails
  13. Cannot delete or update a parent row: a foreign key constraint fails
  14. Rename a column in MySQL
  15. Cannot delete or update a parent row: a foreign key constraint fails
  16. How do I import an SQL file using the command line in MySQL?
  17. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  18. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  19. When to use SELECT … FOR UPDATE?
  20. SQL Query Where Field DOES NOT Contain $x
  21. What is the difference between JOIN and UNION?
  22. Create a new database with MySQL Workbench
  23. MySQL Multiple Joins in one query?
  24. Error Code: 2013. Lost connection to MySQL server during query
  25. Column ‘user_id’ in field list is ambiguous
  26. How to join two tables by multiple columns in SQL?
  27. How to get size of mysql database?
  28. Selecting data from two different tables without using joins
  29. MySQL: Invalid use of group function
  30. Creating a search form in PHP to search a database?
  31. Simple Random Samples from a Sql database
  32. What does SQL clause “GROUP BY 1” mean?
  33. SQL ZOO List each continent and the name of the country that comes first alphabetically
  34. How can I prevent SQL injection in PHP?
  35. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  36. Generating a random & unique 8 character string using MySQL
  37. SQL select only rows with max value on a column
  38. Unknown Column In Where Clause
  39. Repair all tables in one go
  40. MySQL equivalent of DECODE function in Oracle
  41. How to create a foreign key in phpmyadmin
  42. How to check if mysql database exists
  43. Join vs. sub-query
  44. #1062 – Duplicate entry for key ‘PRIMARY’
  45. Is there a Profiler equivalent for MySql?
  46. Remove Primary Key in MySQL
  47. MySQL: Cloning a MySQL database on the same MySql instance
  48. Is merge statement available in MySQL
  49. How to get the count of each distinct value in a column?
  50. Data is not constantly loading from custom wordpress table
  51. How do you properly prepare a %LIKE% SQL statement?
  52. Optimize WordPress Query that take 5 seconds to execute
  53. Getting wrong relationship value in $args in wp_Query?
  54. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  55. Inserting Post Meta From SQL
  56. Extending the database
  57. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  58. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  59. Query WordPress database by registered date and role
  60. Size article thumbnails and retrieve them directly from database
  61. SQL Error wp_commentmeta – incorrect table definition
  62. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  63. Database Tables Lost Indexes? How to Recover?
  64. SQL Database, repeated tables?
  65. Create table from array with prepare
  66. Migrating to WordPress Recipe Plugin and Some SQL Issues
  67. Code to remove authors with no posts connected to them
  68. SQL command to convert all tags in lowercase?
  69. SQL Query in WordPress – Getting Impossible WHERE error
  70. Why this query is not showing any result on wordpresss home page?
  71. Using AND and bracket grouping in SQL not working
  72. Why does changing Database Table Prefixes result in loss of content?
  73. WP MultiSite: Can’t select database error after changing to new domain
  74. How can I write a formal sql query to get data from a custom table
  75. $wpdb->get_var – What value is returned when zero records are found?
  76. Data is not constatntly loading from custom wordpress table
  77. Lock wait timeout exceeded; try restarting transaction
  78. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  79. SQL query to change custom field in WordPress database
  80. Bulk find & replace on WordPress posts/pages (minus image paths)
  81. How to create index (sql) to a meta_key?
  82. Improving performance of SQL sub-queries in WordPress
  83. Delete all users meta that named: user_avatar
  84. An SQL query to find orphaned image attachments and their meta
  85. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  86. Display MySQL as part of a Page
  87. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  88. can’t delete a row from post_meta table
  89. get_results() query not working only when entering strings
  90. SQL error on restoring database
  91. optimise SQL wordpress call
  92. Query sql for truncate post_content in wp_posts table
  93. Woocommerce: Grab total revenue of a product over all orders
  94. export individual posts to text files or a single csv file
  95. SQL query : Select a thumbnail for a media
  96. SQL – Pull products of particular category from a remote WordPress woocommerce db
  97. why you don’t Implement PDO for access every thing to database
  98. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  99. How do I load a sql.gz file to my database? (importing)
  100. Possible SQL injection. How to locate and fix?

Leave a Comment

tech