---

Search posts under SQL Server:

---

SQL Server > Joins

In this section we are going to learn about the joins in SQL server.

To demonstrate the joins, we will be working on two tables PersonalDetails and Accounts. Where the Primary key table is PersonalDetails with PersonalDetailsId is the primary key. The Foreign key table is Accounts with Personal Details Id.

Read posts under SQL Server > Joins

1. Inner join more than one tables
2. Left join / Left outer join
3. Right join / Right outer join