I have a table T1: that has 3 columns ID1, ID2, Description and i have a file with columns ID, DATE, VALUE, NEXTV. I need to join the two tables but ID field in the file can either be ID1 OR ID2 in T1.
I therefore did a join (T1) ...... where exists (ID1, ID) and another join (T1)..... where exists (ID2, ID) but i understand this isnt working because its trying to do the 2nd join on the other similar fields, DATE, VALUE, NEXTV . A concatenate creates duplicates of ID2 in the resulting T1 with null values in ID1.
