How to use mssql left join

0 Comment

How to use Mssql left join

pkid is primary key and fkid is foreign key releation between two tables if you releation between this tables you can use left join.

Left join means if your left side table does not match the data with right side table it will be return all row from left side table

select * from table1 left join table2 on table1.pkid = table2.Fkid

Please do comments if you have any question. share with your friends.

Tags: , ,

Leave a Reply

Your email address will not be published. Required fields are marked *