Difference between left join and right join in SQL Server [duplicate]

by 
Select * from Table1 left join Table2 ...

and

Select * from Table2 right join Table1 ...

are indeed completely interchangeable. Try however Table2 left join Table1 (or its identical pair, Table1 right join Table2) to see a difference. This query should give you more rows, since Table2 contains a row with an id which is not present in Table1.

More Related Contents:

  1. Are “from Table1 left join Table2” and “from Table2 right join Table1” interchangeable?
  2. Difference between RIGHT & LEFT JOIN vs RIGHT & LEFT OUTER JOIN in SQL [duplicate]
  3. How to display data in JOIN, and return null value? [closed]
  4. SQL update from one Table to another based on a ID match
  5. Can I use CASE statement in a JOIN condition?
  6. Difference between JOIN and INNER JOIN
  7. SQL to LINQ with multiple join, count and left join
  8. Implement paging (skip / take) functionality with this query
  9. Natural join in SQL Server
  10. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  11. Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in more detail
  12. Joining multiple tables in SQL
  13. SQL SELECT from multiple tables
  14. SQL Inner Join On Null Values
  15. Removing duplicate rows (based on values from multiple columns) from SQL table
  16. What is wrong with this DB Diagram? [closed]
  17. I’m getting ‘Column name is invalid in the select list’ error when i execute the query
  18. Efficiently convert rows to columns in sql server
  19. Group by column and multiple Rows into One Row multiple columns
  20. Find the smallest unused number in SQL Server
  21. Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?
  22. I want to use CASE statement to update some records in sql server 2005
  23. Sql Server trigger insert values from new row into another table
  24. Getting the Id of a row I updated in Sql Server
  25. Zero SQL deadlock by design – any coding patterns?
  26. UNION ALL vs OR condition in sql server query
  27. Is there a severe performance hit for using Foreign Keys in SQL Server?
  28. How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?
  29. Date serial in SQL?
  30. Parameterise table name in .NET/SQL?

Leave a Comment