UPDATE PHYSICALRESOURCESPECIFICATIONS PPS
SET PPS.Typeid = (select Temp.TYPEID from Temp where Temp.ID = PPS.ID )
WHERE EXISTS(SELECT 1 FROM Temp WHERE Temp.ID = PPS.ID);
orcal连表更新
最新推荐文章于 2024-05-17 13:53:28 发布
UPDATE PHYSICALRESOURCESPECIFICATIONS PPS
SET PPS.Typeid = (select Temp.TYPEID from Temp where Temp.ID = PPS.ID )
WHERE EXISTS(SELECT 1 FROM Temp WHERE Temp.ID = PPS.ID);