Re: How? Join twice against same table?

From: Alastair Newson <anewson_at_cix.compulink.co.uk>
Date: Fri, 9 Dec 1994 09:33:30 GMT
Message-ID: <D0JEJu.78n_at_cix.compulink.co.uk>

If I've understood your problem correctly try

select a1.field_a1


     , b2.field_b2


     , b3.field_b2


from  aaa a1


     ,bbb b2


     ,bbb b3


where a.field_a2_refb1 = b2.field_b1

  and a.field_a3_refb1 = b3.field_b1   

Obviously this solution relies on there being values in both the foreign keys.

Alastair Newson             'When the best leader's work is done, 
Technical Projects Manager          the people say, 
Glaxo Pharms UK Ltd              "We did it ourselves!"'

44-(0)181-990-3023 Received on Fri Dec 09 1994 - 10:33:30 CET