Home > IT Answers > Development > Joining 3 tables in SQL Server 2005
Macha1973
5 pts.
 Joining 3 tables in SQL Server 2005
SQL Query, SQL query optimization, SQL Server, SQL Server 2005, SQL Server Query, SQL tables
Here are the 3 simple SELECT queries i have but i want to merge them all into 1 singl query.

Software/Hardware used:
SQL Server 2005.
ASKED: August 12, 2010  12:37 PM
UPDATED: August 12, 2010  11:17 PM
RELATED QUESTIONS
Answer Wiki:
As you didn't include the tables, I'll just give you a basic syntax. <pre>SELECT t1.*, t3.*, t2.col1 FROM t1 JOIN t2 ON t1.col1 = t2.col4 JOIN t3 ON t2.col2 = t3.col1 WHERE t1.Col5 = 'test'</pre>
Last Wiki Answer Submitted:  August 12, 2010  11:17 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Your queries didn’t get posted.

carlosdl
 63,580 pts.