Hi - New here- I have 2 tables. I want to sequentially search the value of Table A column 2 to Table B column 1 and 2 in a full outer join. There will not be any cases where there is a match on both Table B column 1 and 32 for the same value from Table A.
Example
Table A
Column 1 Column 2
Bob Jim
Jane Joe
Bill Fred
Table B
Column 1 Column 2
Jim Mary
Tim Tom
Don Fred
Desired Result
Table C (Full Outer Join)
Column 1 Column 2 Column 3 Column 4
Bob Jim Jim Mary
Jane Joe Null Null
Bill Fred Don Fred
Null Null Tim Tom