Case statement in Join

Teradata Employee

Case statement in Join


i have multiple instances of the same table used.

For eg:

A left join b

on a.id1 =

left join B


left join B

on a.id3 =

-- 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)