UPDATE VER_FLOW_UPGREG a
SET closetype=(SELECT b.CLOSETYPEID FROM VER_FLOW_UPGSUMMARY b WHERE a.ID = b.UpgRegID)
WHERE EXISTS (SELECT 1 FROM VER_FLOW_UPGSUMMARY b WHERE a.ID = b.UpgRegID);
SET closetype=(SELECT b.CLOSETYPEID FROM VER_FLOW_UPGSUMMARY b WHERE a.ID = b.UpgRegID)
WHERE EXISTS (SELECT 1 FROM VER_FLOW_UPGSUMMARY b WHERE a.ID = b.UpgRegID);
如果你不在乎,那么可以:
UPDATE VER_FLOW_UPGREG a
SET closetype=(SELECT b.CLOSETYPEID FROM VER_FLOW_UPGSUMMARY b WHERE a.ID = b.UpgRegID and rownum<2)
WHERE EXISTS (SELECT 1 FROM VER_FLOW_UPGSUMMARY b WHERE a.ID = b.UpgRegID);