RIAS
asked on
Query Join
Hello,
Need a suggestion on how to use the join in the following example.
Thanks in advance.
Example5.xlsx
Need a suggestion on how to use the join in the following example.
Thanks in advance.
Example5.xlsx
select t1.Ref, t2.Code from Table1 t1 left outer join Table2 t2 on t1.Ref = t2.Ref
ASKER
Thanks but , how to update the column 'Code' based on the match?
what do you mean "update the column 'Code' based on the match"?
You want to set value of Table1.Code to Table2.Code?
You want to set value of Table1.Code to Table2.Code?
ASKER
yes please.
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect thanks!!