Mssql inner join

0 Comment

How to use Mssql inner join

pkid is primary key and fkid is foreign key releation between two tables if you releation between this tables you can use inner join. inner join used for if your id exists in both table then it will show you data other wise its only showing you data which exists in both.

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