Oracle下的Update语句
有一下2个SQL语句,在SQLServer上都能正常执行,但在Oracle9i下执行不了,不知道是在理论上就不可行还是稍微改动就可以执行:
UPDATE B08 SET B0740=B07.B0740,B0745=B07.B0745,F1044=B07.F1044,F1050=B07.F1050,
F1055=B07.F1055,F1065=B07.F1065,F1070=B07.F1070,F1080=B07.F1080,
F1085=B07.F1085,F1090=B07.F1090,F1095=B07.F1095,F1100=B07.F1100,
F1105=B07.F1105 FROM B07 left JOIN B08 ON B07.UID = B08.UID
where b08.seriesno=0
UPDATE unit SET F1040=B07.F1040
FROM B07 left JOIN unit ON B07.UID = unit.UID