i have multiple instances of the same table used.
A left join b
on a.id1 = 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 ???
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.