Re: SQL need to join 3 tables

[Charles Wilt <charles.wilt@xxxxxxxxx>]

select idType1, idType2,
    t1.info as inforType1,
    t2.info as inforType2
from allClients
       join Type1Clients T1 on idType1 = t1.id
       join Type2Clients T2 on idType1 = t2.id

Charles

On Fri, Jan 28, 2011 at 9:14 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx> wrote:
> 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.