SQL Server Retrieve Data from Multiple Tables using Joins

Introduction:

In this article I will explain how to retrieve data from multiple tables in sql server.

Description:

In previous post I explained Difference b/w functions and stored procedures, Pass table as parameter in SQL Server 2008, differences between char, varchar and nvarchar, difference between tinyint,smallint,int,bigint and many articles relating to SQL Server. Now I will explain how to retrieve data from multiple tables in SQL Server.

If we want to retrieve data from multiple tables we need use Joins Concept in SQL Server.

Joins are used to get data from two or more tables based on relationship between some of the columns in tables for complete details check this article Joins Concept in SQL Server.

Before implement this example first design one table UserInformation in your database as shown below

Column Name	Data Type	Allow Nulls
UserId	Int (Set Identity=true)	No
UserName	varchar(50)	Yes
Location	Varchar(50)	Yes

After that design another table OrderDetails in your database like this

Column Name	Data Type	Allow Nulls
OrderId	Int (Set Identity=true)	No
OrderNo	Int	Yes
UserId	Int	No

After table design complete enter some data like as shown below

UserInfromation

OrderInformation

To get the data from these two tables here I am going to use Inner join concept in SQL Server

Inner Join

The join that displays only the rows that have a match in both the joined tables is known as inner join (Read more)

We need to write the query like as shown below to get data from two tables based on UserId match

SELECT u.UserId,u.UserName,u.Location,o.OrderNo FROM UserInformation u INNER JOIN OrderDetails o ON u.UserId=o.UserId

OutPut

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email