How to use right join mssql

0 Comment

How to use Mssql right join

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

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

select * from table1 right 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 *