#right-join

How to: Difference between left join and right join in SQL Server

Difference between left join and right join in SQL Server

I know about joins in SQL Server.

For example. there is two tables Table1, Table2.

There table structure are following.

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

If i execute both below…