SQL查询问题 - MS-SQL Server / 基础类

有表t,表b,其中t有id,title,content,表b有id,tid,title,content.其中t的id与b的tid是关联的.
现在我想删b中content为空的b记录和t中相应的记录?
该怎么写?
有一天

---

你这个意思是用触发器?

---

删b中content为空的b记录和t中相应的记录

同时删除吗?

---

SQL code:
delete b where content is null
go
delete t where not exists(select 1 from b where tid=t.id)
go

---

SQL code:
delete b where content is null
delete t from t inner join b on t.id=b.tid where b.content is null

---

引用

删b中content为空的b记录和t中相应的记录

同时删除吗?

是的..要两个表中的那些数据同时删除!

---

同时删除要触发器把！
我试试3楼和4楼的方法！

---

SQL code:
delete t from t inner join b on t.id=b.tid where b.content is null
delete b where content is null

---

试一下
SQL code:

delete t ,b
from
b left join t on b.id = t.id where b.content is null

---

首先的问题是tid是主键还是T表中ID是主键？
如果要删除