Question

Access Delete 语法

要求实现SQL SQL类是的语句
delete t1 From table1 as t Left join table2 as t2 on t1.f1=t2.f2 Where t2.f3='abc'

Answer 1

delete from table1 where f1 = (select t1.f1 from table1 as t1, table2 as t2 where t1.f1 = t2.f2 and t2.f3 = 'abc')

用这个应该可以吧。。

Answer 2

建议楼主按以下语句进行尝试：
delete
from
student
where
[student].[no]=1;
或
delete
from
student
where
[no]=1;
分析无法删除的原因：no字段没有加[]，未加[]的字段access未能按字段进行区分执行。另外，在输入语句时需要加"；"，这是语句结束的标示符。
希望我的回答对你有帮助，如有疑问可以留言或在线交流。