这样的update语句,为何在Access可以执行,oracle里面却错,错在哪里?
三张表,
UPDATE T1,
(SELECT T2.F1, T2.F2, T2.F3, T2.F4, T3.id FROM T2,T3 where T2.name = T3.name) AS TableA
SET T1.id = SELECT id FROM TableA
WHERE T1.F1=Talbe.F1
AND T1.F2=Talbe.F2
AND T1.F3=Talbe.F3
AND T1.F4=Talbe.F4
如何改呢?