How will you differentiate a left join and right join in SQL Server?

Question

Let’s say there are two tables Table1, Table2.

We have the following table structure for them.

create table Table1 (id int, Name varchar (10))

create table Table2 (id int, Name varchar (10))

Table1 data as follows:

    Id     Name     

    -------------

    1      A        

    2      B    

Table2 data as follows:

    Id     Name     

    -------------

    1      A        

    2      B 

    3      C

Output is same for both the mentioned statements given down below: 

select *

from Table1

  left join Table2 on Table1.id = Table2.id

select *

from Table2

  right join Table1 on Table1.id = Table2.id

Please explain the difference between left and right join in the above SQL statements.

Answer 1

These two queries 

Select * from Table1 left join Table2 ...

and

Select * from Table2 right join Table1 …

Are actually interchangeable. But  Table2 left join Table1 and its identical pair, Table1 right join Table2 to find out the difference. The query should give you more rows because table2 is having a row with id which is not present in Table1.

If you want to get more insights into SQL, check out this SQL Course from Intellipaat.