What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]

by

There is no difference at all.

First representation makes query more readable and makes it look very clear as to which join corresponds to which condition.

More Related Contents:

  1. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  2. 1052: Column ‘id’ in field list is ambiguous
  3. Join tables with SUM issue in MYSQL
  4. Join between tables in two different databases?
  5. Required to join 2 tables with their FKs in a 3rd table
  6. How can I join multiple SQL tables using the IDs?
  7. Why does MySQL report a syntax error on FULL OUTER JOIN?
  8. Mixing ANSI 1992 JOINs and COMMAs in a query
  9. Using an Alias in SQL Calculations
  10. Cumulative sum over a set of rows in mysql
  11. MySQL JOIN the most recent row only?
  12. How to find non-existing data from another Table by JOIN?
  13. MySQL Inner Join Query Multiple Tables
  14. Difference between these two joining table approaches?
  15. Laravel join with 3 Tables
  16. MySQL LEFT JOIN 3 tables
  17. how to use a like with a join in sql?
  18. When to use a left outer join?
  19. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  20. In what order are MySQL JOINs evaluated?
  21. How to store a one to many relation in MySQL database?
  22. MySQL Multiple Joins in one query?
  23. get first occurrence of last changed value of a column [closed]
  24. ROW_NUMBER() in MySQL
  25. How can I temporarily disable a foreign key constraint in MySQL?
  26. Creating a “Numbers Table” in MySQL
  27. MYSQL Select MAX Date inside a join statement
  28. Why do results from a SQL query not come back in the order I expect?
  29. MySQL combine two columns and add into a new column
  30. How to set a MySQL row to READ-ONLY?

Leave a Comment