我有两个表,一个叫GOODS,一个叫pureceiptgoods,两个表里面都有goods与unitprice这个字段
pureceiptgoods表里面有部分unitprice是空的
如何让pureceiptgoods表里面的unitprice等于goods表里面的unitprice,条件是两个表里面的goods字段要相对应上!
如何用SQL语句实现,在线等,谢谢
pureceiptgoods表里面有部分unitprice是空的
如何让pureceiptgoods表里面的unitprice等于goods表里面的unitprice,条件是两个表里面的goods字段要相对应上!
如何用SQL语句实现,在线等,谢谢
SET unitprice=goods.unitprice
FROM goods
WHERE pureceiptgoods.goods=goods.goods
set a.unitprice=b.unitprice
from pureceiptgoods a
join goods
on a.goods=b.goods
where a.unitprice is null
set a.unitprice=b.unitprice
from goods a,pureceiptgoods b
where a.goods=b.goods
update a
set a.unitprice = b.unitprice
from pureceiptgoods a
inner join GOODS b
on a.goods = b.goods
SET unitprice=goods.unitprice
FROM goods,pureceiptgoods
WHERE pureceiptgoods.goods=goods.goods
and pureceiptgoods.unitprice is null