Dear viewer I will show to join two tables based on the relation of two tables. SQL Server join is performed using join keyword and using on keywords. Hear for example I have created two tables which are related to each other that means parent and child table relationship. The parent table name is Department and child table name is Employee .Hear ID is the primary key of Department table which is known as primary column .This DepId is also known as a foreign key for Employee table.