I needed to change the original data as I cannot post my workbook here.
I have table A ( main Table)
Transport Mode (Key identifier)
I need to joint it to a second table with the following two Key Identifier. Both are in one table:
I need to do a left join as I need all data from the main table and need to link it to the second table for additional information. I did a left join with Trans1 but for the identifier that do not match I would like to use Trans2.
Is there a custom SQL script I can use, I cannot have duplicates and empty fields in my main table.