Joining multiple tables in SQL

by

When joining multiple tables the output of each join logically forms a virtual table that goes into the next join.

So in the example in your question the composite result of joining the first 5 tables would be treated as the left hand table.

See Itzik Ben-Gan’s Logical Query Processing Poster for more about this.

The virtual tables involved in the joins can be controlled by positioning the ON clause. For example

SELECT *
FROM   T1
       INNER JOIN T2
         ON T2.C = T1.C
       INNER JOIN T3
                  LEFT JOIN T4
                    ON T4.C = T3.C
         ON T3.C = T2.C

is equivalent to (T1 Inner Join T2) Inner Join (T3 Left Join T4)

More Related Contents:

  1. How to display data in JOIN, and return null value? [closed]
  2. SQL update from one Table to another based on a ID match
  3. Can I use CASE statement in a JOIN condition?
  4. Difference between JOIN and INNER JOIN
  5. Difference between left join and right join in SQL Server [duplicate]
  6. Implement paging (skip / take) functionality with this query
  7. Natural join in SQL Server
  8. SQL Inner Join On Null Values
  9. Removing duplicate rows (based on values from multiple columns) from SQL table
  10. Get the mentioned output by SQL query
  11. I need help formatting inner join command in SQL query
  12. Calculate a Running Total in SQL Server
  13. SQL transpose full table
  14. How to Create a real one-to-one relationship in SQL Server
  15. Select statement to find duplicates on certain fields
  16. Getting only Month and Year from SQL DATE
  17. How to fetch the row count for all tables in a SQL SERVER database [duplicate]
  18. WHERE Clause vs ON when using JOIN
  19. Using a Variable in OPENROWSET Query
  20. Does MS SQL Server’s “between” include the range boundaries?
  21. Check for file exists or not in sql server?
  22. Split one column value into multiple column values
  23. “Order By” using a parameter for the column name
  24. How do I create and query linked database servers in SQL Server?
  25. Add emoji / emoticon to SQL Server table
  26. Perform regex (replace) in an SQL query
  27. What is the internal representation of datetime in sql server?
  28. How do I change db schema to dbo
  29. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  30. How to insert into a table with just one IDENTITY column?

Leave a Comment