As iam new to SQL Server. My question is how to maintain relationship between 2 tables using Joins i.e using primary key. As i have created 2 tables named Employees and Orders.In that i've used 2 primary keys. but iam getting error. So can anybody help me regarding this topic. A full description is required. Please help me. Regards, Sami.