SQL Server – Joins – Type of Joins with simple Example

Joins are use to extract data from more than one tables based on primary key and foreign key relationship between tables. Basically joins are used to generate reports on daily basis. Type of joins in Sql server Inner Join also known as Equi Join Outer Join Cross Join or Cross Product like 2 x 3 =6 ...