j2911
asked on
Code Help wih Joins
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.
TEST.zip
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.
TEST.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Although I appreciate your help - I don't do well learning with theory but something I can see. Would someone have the time to help me out here?
ASKER