在SQL里可以，在ACCESS里不行！帮帮手吧！

[Longchao]

DELETE [图库] FROM (Select ID From [图库查询] Where ID IS Not Null And id>100) AS 图库查询结果 Where 图库查询结果.ID=图库.ID

怎么办？

[happydreamer]

--要这样写

DELETE [图库] WHREE ID IN (Select ID From [图库查询] Where ID IS Not Null And id>100) AS 图库查询结果 Where 图库查询结果.ID=图库.ID

[jpyc]

看看先

[pengdali]

DELETE [图库] where id in (Select ID From [图库查询] Where ID IS Not Null And id>100)

[flc]

DELETE 数据 where
id in
(Select ID From 表 Where ID 满足的条件)

[firetoucher]

同意楼上，还快俄
--------------------------------------
看见了么，
那支蛾子，
正飞向太阳，
那就是我！
--------------------------------------