Hello community,
I'm trying to do this:
Select a.*,
b.return_code as return_code1
c.return_code as return_code2
...
From Core_Data as a
Left Lookup_Table1 as b
on a.key1 = b.key
Left Lookup_Table1 as c
on a.key2 = c.key
...
I have two lookup tables, that I need to join about 30 times each. In healthcare, you can have multiple diagnosis codes and multiple procedure codes.
When I use a Join Multiple, it wants me to select for each record a value for each table. So, if I say a.key, it will ask me what both tables b and c should be matching on. But I want to join a to b, regardless of what is in table c and separately a to c, regardless of what is in table b.
In this case, will I need to do 60 different single-joins (and 60 unions for left joins)?
Best wishes,
Joe Kelly
