blog.mindbirdsolutions.com
Joins in SQL Server 2005 | Teck Trip from Mind Bird Solutions we design bangalore
In this article, we are going to discuss SQL Server Joins. A join is used to combine columns from two or more tables into a single result set. To join data from two tables you write the names of two tables in the FROM clause along with JOIN keyword and an ON phrase that specifies the join condition. The join condition indicates how two tables should be compared. In most cases they are compares on the base on the relationship of primary key of the first table and foreign key of the second table. In this article I will tell you about three important joins. 1. Inner Join 2. Outer Join I have two tables - Vendor table and Advance table. This is how my database tables and data looks like. I will be using these tables in my samples below. Vendor table: Figure 1. Advance table: Figure 2. Now we are going to apply joins on these tables and see the data results. Inner Joins An inner join requires each record in the two joined tables to have a matching