multiple on clauses on outer join

[tmartin99]

I have a problem, I need to be able to pull fields from a table and can have 2 possible id's that can refer to the same id field in the table but come from 2 different tables.
I need to be able to do syntax like the following:

LEFT OUTER JOIN
chrisprd.TASSIGNMENT A
on chrisprd.TREF_CLIENT.REFER_ID chrisprd.TASSIGNMENT.D_ENT_FOR_ID
or
on chrisprd.TCAS_CLIENT.CAS_ID = chrisprd.TASSIGNMENT.D_END_FOR_ID

Does anyone know how to perform this join?

 

[tlbroadbent]

You can't use an OR in the ON clause. Join the table twice.

LEFT JOIN chrisprd.TASSIGNMENT A
on chrisprd.TREF_CLIENT.REFER_ID = A.D_ENT_FOR_ID
LEFT JOIN chrisprd.TASSIGNMENT B
on chrisprd.TCAS_CLIENT.CAS_ID = B.D_END_FOR_ID Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[tmartin99]

OK thanks, also I'm having a mind cramp, if one of the tables on the right side that I'm joining has multiple rows per id and I just want to select one of them how can I do that?