Question

两个表有相同的字段,现在要删除一个表的内容另一个表的内容也跟着删除,SQL语句怎么写

Answer 1

如果你非要同时删除，那你可以：
1、创建一个触发器（适用于每次删除A表，都要删除B表）：
CREATE TRIGGER [tr_del_pk] ON [表A]
FOR DELETE
AS
delete 表A from deleted
where 字段1= deleted.字段1
delete 表2 from deleted
where 字段2 = deleted.字段2
2、写个循环（如果你删除带有条件，并且条件可能随时变动）：
declare @count int
set @count = 1
begin
delete from 表A where 字段1 <= @count
delete from 表B where 字段2 <= @count
end
3、直接删除（一次执行，条件基本固定）
delete from 表A where .....
delete from 表B where .....

Answer 2

那就要写两个sql了吧！！！

追问

是先删一个表再删另一个表?能不能能通过他们相同的字段同时删除

追答

delete from 表一，表二 where 表一.相同字段=表二.相同字段 and 相同字段=‘条件值’

你试一下