Case statement in Join

General
Teradata Employee

Case statement in Join

Hi 

i have multiple instances of the same table used.

For eg:

A left join b

on a.id1 = b.id

left join B

on a.id2=b.id

left join B

on a.id3 = b.id

-- and then selecting records from different instances of B

----------------------------

instead of using B multiple times can i hope i can write 

a left join B

with case statement-- and seelct records from that

Any help in the syntax ???

Tags (1)