SQL Server - joining 3 select queries

hi all
 i need to join three select queries like

my select queries are

select * from table1
order by table1.ID

select * from table2
order by table2.ID

select * from table3
order by table3.ID

ID is a primary key which is common in all of these tables

thanks in advance
MUTHU

hi,

Join is possible if you have one command field in both table which you are joining. since you have to provide any field that are existing in both table. I am assuming that you have id field is common in the 2 table and according to it here is the eg query for you


Hope this will help you

Follow this example-

I have the following tables (and example values):

user: user_id (1, 2, 3) username (john33, reddiamond...) password (pass1, pass2...)

session: session_id (4,5, 6) user_id (1, 2, 3)

activity activity_id (1, 2) name (running, walking...)

user_activity user_activity_id (1, 2, 3, 4, 5) session_id (4, 5) activity_id (1, 2)

Solution-

SELECT u.username, a.name
FROM user_activity ua
INNER JOIN session s
ON ua.session_id = s.session_id
INNER JOIN user u
ON s.user_id = u.user_id
INNER JOIN activity a
ON ua.activity_id = a.activity_id


Refer this for more details
http://msdn.microsoft.com/en-us/library/aa213227%28v=sql.80%29.aspx

You can use Join to join your three tables and display the result..

your query looks like below

Select tbl1.* , tbl2.* , tbl3.*
From
Table1 tbl1
Inner Join Table2 tbl2 ON tbl1.ID = tbl2.ID
Inner Join Table3 tbl3 ON tbl2.ID = tbl3.ID