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. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  11. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  12. How can I do a FULL OUTER JOIN in MySQL?
  13. Cannot delete or update a parent row: a foreign key constraint fails
  14. Cannot delete or update a parent row: a foreign key constraint fails
  15. Case statement in MySQL
  16. Rename a column in MySQL
  17. Cannot delete or update a parent row: a foreign key constraint fails
  18. How do I import an SQL file using the command line in MySQL?
  19. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  20. How do I quickly rename a MySQL database (change schema name)?
  21. What does SQL Select symbol || mean?
  22. What is the definition of cardinality in SQL
  23. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  24. When to use SELECT … FOR UPDATE?
  25. SQL Query Where Field DOES NOT Contain $x
  26. What is the difference between JOIN and UNION?
  27. Create a new database with MySQL Workbench
  28. MySQL Multiple Joins in one query?
  29. Error Code: 2013. Lost connection to MySQL server during query
  30. Column ‘user_id’ in field list is ambiguous
  31. How to join two tables by multiple columns in SQL?
  32. How to get size of mysql database?
  33. mysql Foreign key constraint is incorrectly formed error
  34. Selecting data from two different tables without using joins
  35. how to drop partition without dropping data in MySQL?
  36. MySQL: Invalid use of group function
  37. Creating a search form in PHP to search a database?
  38. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  39. Simple Random Samples from a Sql database
  40. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  41. What does SQL clause “GROUP BY 1” mean?
  42. SQL ZOO List each continent and the name of the country that comes first alphabetically
  43. How can I prevent SQL injection in PHP?
  44. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  45. Generating a random & unique 8 character string using MySQL
  46. SQL select only rows with max value on a column
  47. Unknown Column In Where Clause
  48. SQL statement not working – “Operand type clash: date is incompatible with int’
  49. Convert partially non-numeric text into number in MySQL query
  50. Repair all tables in one go
  51. MySQL equivalent of DECODE function in Oracle
  52. How can I search (case-insensitive) in a column using LIKE wildcard?
  53. How to create a foreign key in phpmyadmin
  54. importing a CSV into phpmyadmin
  55. How to check if mysql database exists
  56. Join vs. sub-query
  57. #1062 – Duplicate entry for key ‘PRIMARY’
  58. Is there a Profiler equivalent for MySql?
  59. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  60. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  61. Remove Primary Key in MySQL
  62. select * from table where column = something or, when unavailable, column = something else
  63. MySQL: Cloning a MySQL database on the same MySql instance
  64. Is merge statement available in MySQL
  65. How to get the count of each distinct value in a column?
  66. Data is not constantly loading from custom wordpress table
  67. How do you properly prepare a %LIKE% SQL statement?
  68. What SQL Query to do a simple find and replace
  69. What’s a good strategy for planning WordPress DB growth?
  70. Optimize WordPress Query that take 5 seconds to execute
  71. Scanning Database for malicious Data
  72. Getting wrong relationship value in $args in wp_Query?
  73. wpdb->prepare function remove single quote for %s in SQL statment
  74. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  75. Inserting Post Meta From SQL
  76. How to Join two tables from separate databases within WordPress
  77. Extending the database
  78. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  79. How to execute mulitple statement SQL queries using $wpdb->query?
  80. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  81. Query WordPress database by registered date and role
  82. Size article thumbnails and retrieve them directly from database
  83. wpdb_prepare with multiple or condition
  84. How do I find which articles are missing a featured image in The WordPress database?
  85. SQL Error wp_commentmeta – incorrect table definition
  86. How to find meta entries with their posts missing via SQL?
  87. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  88. How do I get the posts within a certain year/date(with sql query)?
  89. Database Tables Lost Indexes? How to Recover?
  90. SQL Database, repeated tables?
  91. Create table from array with prepare
  92. Migrating to WordPress Recipe Plugin and Some SQL Issues
  93. Code to remove authors with no posts connected to them
  94. SQL command to convert all tags in lowercase?
  95. Which is better and faster ? WordPress Queries or SQL Query
  96. SQL Query in WordPress – Getting Impossible WHERE error
  97. Why this query is not showing any result on wordpresss home page?
  98. Using AND and bracket grouping in SQL not working
  99. Why does changing Database Table Prefixes result in loss of content?
  100. How to get INSERT errors from $wpdb?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)