Creating a new table with a calculated column by joining two tables depending on the match

andhiii079845 In both the table that 2 columns are the only match column then thor table is the left table and we are using left outer join later we are doing some business logic calculation to avoid the duplicates but we are not getting expected result.  Sharing screenshot for your reference from actual data. red box are duplicates value. one Thor ID should match with one CWR ID.