INNER JOIN vs multiple table names in “FROM” [duplicate]

by

There is no reason to ever use an implicit join (the one with the commas). Yes for inner joins it will return the same results. However, it is subject to inadvertent cross joins especially in complex queries and it is harder for maintenance because the left/right outer join syntax (deprecated in SQL Server, where it doesn’t work correctly right now anyway) differs from vendor to vendor. Since you shouldn’t mix implicit and explict joins in the same query (you can get wrong results), needing to change something to a left join means rewriting the entire query.

More Related Contents:

  1. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  2. INNER JOIN ON vs WHERE clause
  3. Difference between JOIN and INNER JOIN
  4. SQL Inner-join with 3 tables?
  5. Multiple INNER JOIN SQL ACCESS
  6. Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?
  7. Update statement with inner join on Oracle
  8. SQL JOIN and different types of JOINs
  9. SQL update from one Table to another based on a ID match
  10. How can I delete using INNER JOIN with SQL Server?
  11. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  12. SQL left join vs multiple tables on FROM line?
  13. SQL Joins Vs SQL Subqueries (Performance)?
  14. SQLite – How do you join tables from different databases?
  15. Unrecognized name: employees at [9:8]
  16. What’s the best way to join on the same table twice?
  17. Can we use join for two different database tables?
  18. Call a set-returning function with an array argument multiple times
  19. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  20. MySQL – Selecting data from multiple tables all with same structure but different data
  21. Record returned from function has columns concatenated
  22. ORA – 00933 confusion with inner join and “as”
  23. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  24. Venn Diagram for Natural Join
  25. SQL query: Simulating an “AND” over several rows instead of sub-querying
  26. Why do multiple-table joins produce duplicate rows?
  27. SQL SELECT from multiple tables
  28. IN vs. JOIN with large rowsets
  29. SQL INNER JOIN syntax
  30. SQL join on multiple columns in same tables

Leave a Comment