'Duplicate values on join

I am trying to create a table using the following query:

PROC SQL;
    CREATE TABLE NEW_TABLE AS
        SELECT A.* ,B.FIELD_1, B.FIELD_2
            FROM TEST AS A
                LEFT JOIN OTHER_TABLE AS B ON A.CONTRACT = B.CONTRACT
                    AND (A.CUSTOMER = B.CUSTOMER OR A.CUSTOMER_NEW = B.CUSTOMER);
QUIT;

but that query returns duplicate values. I am guessing that the OR i am using on the join is causing that because in some cases it will match one of the conditions or both. Also i am removing duplicates on OTHER_TABLE before i do the join. How can i make it match A.CUSTOMER = B.CUSTOMER and then A.CUSTOMER_NEW = B.CUSTOMER only if it didn't find a match for the first one? I am using left join because i want to keep all the records in TEST and get null values when it does not find anything even after checking those conditions.

sqlsas


Solution 1:[1]

you use left join , make sure all fields are not the same, maybe one field are different

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 fatemeh Qanbari

Related Questions