Re: SQL need to join 3 tables

select *
from allClients a
left join Type1Clients t1
on a.idType1 = t1.id
left join Type2Clients t2
on a.idType2 = t2.id

Dieter

--------------------------------------------------
From: "David FOXWELL" <David.FOXWELL@xxxxxxxxx>
Sent: Friday, January 28, 2011 3:14 PM
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Subject: SQL need to join 3 tables

Hi all,

I have this tricky (for me) table join to make. I need to get the info field out of tables Type1Clients and Type2Clients so I have the resultTable shown at the bottom.

I could join AllClients to Type1Clients then union this with AllClients joined to Type2Clients but that won't give me all the information in one row. How can I do this?
Thanks.


AllClients
idType1 idType2
1_0001 2_0001
1_0002 2_0002


Type1Clients
id info
1_0001 i101
1_0002 i102

Type2Clients
id info
2_0001 i201
2_0002 i202

resultTable
idType1 idType2 infoTyp1 infoTyp2
1_0001 2_0001 i101 i201
1_0002 2_0002 i201 i201



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.