Question

sql的delete怎样同时删除多个表中的记录？

delete from table1 where field a=N delete from table2 where field b=N and c=N 怎样把这两个表用一个delete删掉呢？ 这样写肯定是错的delete from table1 ，table2 where a=N and b=N and c=N 那该如 何写sql语句才能按照where条件一次性的删除两个表中的记录呢？

Answer 1

delete from table1 ，table2 where a=N or(b=N and c=N)

Answer 2

delete 只能删除一张表吧