SQlServer
:Update Table1 Set aa='D' Where bb=(Select bb From Table2)Access
:UpDate Table1,Table2 Set aa='D' Where Table1.bb=Table2.bb
:Update Table1 Set aa='D' Where bb=(Select bb From Table2)Access
:UpDate Table1,Table2 Set aa='D' Where Table1.bb=Table2.bb
from TableA a,TableB b
where a.bb = b.bb
token: from
line number:1;
关键字出错,通不过。
^^
注意是:in而不是=。