Link to home
Start Free TrialLog in
Avatar of RIAS
RIASFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Query Join

Hello,

Need a suggestion on how to use the join in the following example.

Thanks in advance.
Example5.xlsx
Avatar of OMC2000
OMC2000
Flag of Russian Federation image

select t1.Ref, t2.Code from Table1 t1 left outer join Table2 t2 on t1.Ref = t2.Ref
Avatar of RIAS

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?
Avatar of RIAS

ASKER

yes please.
Thanks
ASKER CERTIFIED SOLUTION
Avatar of OMC2000
OMC2000
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RIAS

ASKER

Perfect thanks!!