作业帮 > 综合 > 作业

Access Delete 语法

来源:学生作业帮 编辑:搜狗做题网作业帮 分类:综合作业 时间:2024/06/11 06:04:25
Access Delete 语法
要求实现SQL SQL类是的语句
delete t1 From table1 as t Left join table2 as t2 on t1.f1=t2.f2 Where t2.f3='abc'
Access Delete 语法
delete from table1 where f1 = (select t1.f1 from table1 as t1,table2 as t2 where t1.f1 = t2.f2 and t2.f3 = 'abc')
用这个应该可以吧.