Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?

by

You need to give the user table an alias the second time you join to it

e.g.

SELECT article . * , section.title, category.title, user.name, u2.name 
FROM article 
INNER JOIN section ON article.section_id = section.id 
INNER JOIN category ON article.category_id = category.id 
INNER JOIN user ON article.author_id = user.id 
LEFT JOIN user u2 ON article.modified_by = u2.id 
WHERE article.id = '1'

More Related Contents:

  1. How can I do a FULL OUTER JOIN in MySQL?
  2. INNER JOIN ON vs WHERE clause
  3. Join vs. sub-query
  4. Subqueries vs joins
  5. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  6. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  7. MySQL – Selecting data from multiple tables all with same structure but different data
  8. MySQL: GROUP_CONCAT with LEFT JOIN
  9. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  10. How to display data in JOIN, and return null value? [closed]
  11. You can’t specify target table for update in FROM clause
  12. SQL to LINQ with multiple join, count and left join
  13. How do I make a row generator in MySQL?
  14. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  15. MySQL number of items within “in clause”
  16. Oracle “(+)” Operator
  17. Error 1046 No database Selected, how to resolve?
  18. JOIN two SELECT statement results
  19. What’s the difference between VARCHAR and CHAR?
  20. Alter a MySQL column to be AUTO_INCREMENT
  21. single fixed table with multiple columns vs flexible abstract tables
  22. Mixing implicit and explicit JOINs
  23. MySQL JOIN the most recent row only?
  24. Is it possible to have an indexed view in MySQL?
  25. mysql – how many columns is too many?
  26. Use A Union Or A Join – What Is Faster [closed]
  27. MySQL: Compare differences between two tables
  28. Mysql strip time component from datetime
  29. SQL Inner Join On Null Values
  30. How do MySQL views work?

Leave a Comment