delete from t1 from t1,t2 where t1.f1=t2.f3 and t1.f2=t2.f4 不知可以不可以.
楼上的语句肯定不行,有两个from。
delete a from 表1 a,表2 b where a.字段1 = b.字段1 and a.字段2=b.字段2 調試通過 Delete A from t1 A Inner Join t2 B On A.f1=B.f3 And A.f2=B.f4 通過 delete from t1 from t1,t2 where t1.f1=t2.f3 and t1.f2=t2.f4 通過
学了一招,delete from t1 from t1,t2 where t1.f1=t2.f3 and t1.f2=t2.f4 确实可以
不知可以不可以.
where a.字段1 = b.字段1 and a.字段2=b.字段2
調試通過
Delete A from t1 A Inner Join t2 B On A.f1=B.f3 And A.f2=B.f4
通過
delete from t1 from t1,t2 where t1.f1=t2.f3 and t1.f2=t2.f4
通過
确实可以