17,088
社区成员
发帖
与我相关
我的任务
分享
update biao2 b2 set b2.sale =(select b1.sale from biao1 b1 where b1.id_man =b2.id_man)
如果条件再严格一点,再加上
where b1.id_man in (select id_man from biao2)
MERGE INTO products p
USING newproducts np
ON (p.product_id = np.product_id)
WHEN MATCHED THEN
UPDATE
SET p.product_name = np.product_name
WHERE p.category = np.category;