Hi - I am struggling with trying to get this join to work as it should.
I am attaching the code and the files needed to reproduce it.
I am trying to match up for every entry of diff.compr_fld_nm and bring in the fn.g_field_name for it.
Also trying to match up every entry of test_SCN1_id and bring in the ship_ID for it as well.
All I am getting is duplicates.