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. Case statement in MySQL
  12. Cannot delete or update a parent row: a foreign key constraint fails
  13. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  14. How do I quickly rename a MySQL database (change schema name)?
  15. What does SQL Select symbol || mean?
  16. What is the definition of cardinality in SQL
  17. When to use SELECT … FOR UPDATE?
  18. What is the difference between JOIN and UNION?
  19. Create a new database with MySQL Workbench
  20. Error Code: 2013. Lost connection to MySQL server during query
  21. How to join two tables by multiple columns in SQL?
  22. How to get size of mysql database?
  23. mysql Foreign key constraint is incorrectly formed error
  24. Selecting data from two different tables without using joins
  25. how to drop partition without dropping data in MySQL?
  26. MySQL: Invalid use of group function
  27. Creating a search form in PHP to search a database?
  28. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  29. Simple Random Samples from a Sql database
  30. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  31. What does SQL clause “GROUP BY 1” mean?
  32. SQL ZOO List each continent and the name of the country that comes first alphabetically
  33. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  34. SQL select only rows with max value on a column
  35. SQL statement not working – “Operand type clash: date is incompatible with int’
  36. Convert partially non-numeric text into number in MySQL query
  37. Repair all tables in one go
  38. How can I search (case-insensitive) in a column using LIKE wildcard?
  39. importing a CSV into phpmyadmin
  40. How to check if mysql database exists
  41. Join vs. sub-query
  42. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  43. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  44. Remove Primary Key in MySQL
  45. select * from table where column = something or, when unavailable, column = something else
  46. MySQL: Cloning a MySQL database on the same MySql instance
  47. Is merge statement available in MySQL
  48. What SQL Query to do a simple find and replace
  49. What’s a good strategy for planning WordPress DB growth?
  50. Scanning Database for malicious Data
  51. wpdb->prepare function remove single quote for %s in SQL statment
  52. How to Join two tables from separate databases within WordPress
  53. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  54. How to execute mulitple statement SQL queries using $wpdb->query?
  55. Query WordPress database by registered date and role
  56. Size article thumbnails and retrieve them directly from database
  57. wpdb_prepare with multiple or condition
  58. How do I find which articles are missing a featured image in The WordPress database?
  59. SQL Error wp_commentmeta – incorrect table definition
  60. How to find meta entries with their posts missing via SQL?
  61. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  62. How do I get the posts within a certain year/date(with sql query)?
  63. Database Tables Lost Indexes? How to Recover?
  64. SQL Database, repeated tables?
  65. Create table from array with prepare
  66. Code to remove authors with no posts connected to them
  67. Which is better and faster ? WordPress Queries or SQL Query
  68. SQL Query in WordPress – Getting Impossible WHERE error
  69. Why this query is not showing any result on wordpresss home page?
  70. Using AND and bracket grouping in SQL not working
  71. How to get INSERT errors from $wpdb?
  72. SQL query to set posts in bulk based on the post content
  73. MySQL query for taxonomy-meta
  74. How can I write a formal sql query to get data from a custom table
  75. latency problems with wordpress install (from SQL import)
  76. DB prefix not updating
  77. Performing CRUD operations on front end in wordpress
  78. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  79. Find locations of all featured images of draft posts via SQL
  80. SQL query to change custom field in WordPress database
  81. Bulk find & replace on WordPress posts/pages (minus image paths)
  82. How to show result of sql query in a page?
  83. update_option returns false in AJAX, how to debug?
  84. How to create index (sql) to a meta_key?
  85. Improving performance of SQL sub-queries in WordPress
  86. The function is deprecated; use mysql_real_escape_string() instead
  87. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  88. WPDB delivers wrong results from complex queries
  89. How to change link in all posts?
  90. Display MySQL as part of a Page
  91. get_results() query not working only when entering strings
  92. Query sql for truncate post_content in wp_posts table
  93. Woocommerce: Grab total revenue of a product over all orders
  94. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  95. Delete posts with word count less than x number of words
  96. SQL query : Select a thumbnail for a media
  97. SQL command to export post_content from wp_posts using phpMyAdmin
  98. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  99. SQL get last entry of a specific gravity form
  100. How do I load a sql.gz file to my database? (importing)

Leave a Comment

tech