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

This question already has answers here: What is the difference between “INNER JOIN” and “OUTER JOIN”? (27 answers) Closed 1 year ago. I know about joins in SQL Server. For example. There are two tables Table1, Table2. Their table structures are the following. create table Table1 (id int, Name varchar (10)) create table Table2 (id … Read more