I have 2 queries like this:
Select F_Exhibitor,F_Stand from t_order_header where F_Exhibition='10996'
AND
select F_ExhibitorCode,F_Stand from T_ExhibitorLocation where F_ExhibitionCode='10996'
I want to update T_order_header
table F_stand with corresponding F_ExhibitorCode and F_stand name in the T_ExhibitorLocation
Hoping to have correctly understood the request, the update query could be something like
UPDATE o
SET o.F_Stand = e.F_Stand
FROM t_order_header o INNER JOIN T_ExhibitorLocation e ON e.F_ExhibitionCode = F_Exhibition
--optional where code
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments