SQL Recipes (Beta II)
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers
How to use two joins in a single query? How to use two joins in a single query?

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 11-26-2006, 10:12 PM
Vaibhav Pingl
 
Posts: n/a
Default MS SQL dialect question:

How to use two joins in a single query?

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 11-29-2006, 05:59 PM
ben ben is offline
Administrator
  
Join Date: Mar 2007
Posts: 77
ben has disabled reputation
Default SQL 92 answer. Re: How to use two joins in a single query?
SELECT * FROM TABLE AS t1
JOIN table2 AS t2 ON t2.t1_id = t1.id
JOIN table3 AS t3 ON t3.t1_id = t1.id

In this example table2 and table 3 are children of table1 and both have a foreign key field named t1_id
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« How to form Query for details given? | How to query for valid email address with _@_._ format? »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Moderation Tools:


Similar Threads
Thread Thread Starter Forum Replies Last Post
can i wrire a query which sum up more than 2 columns in a single table? kajal SQL - Questions and Answers 2 03-06-2007 12:41 AM
Do two joins in a single query? Scott SQL - Questions and Answers 2 06-08-2006 03:16 AM


All times are GMT. The time now is 07:48 AM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2007 SQL Recipes

1 2 3 4 5 6 7