怎么删除2个表里相关的数据

如何删除2个表里相关的数据？
A：

id     hyid     hynumber       isok
123     123       1001               0
133     135       1002               1

B:

id       hyname
123       李
135       陈

（注：A.hyid=B.id）

如何删除A表里isok=0的那条数据，并删除B表中关联的数据？谢谢~~~

[解决办法]
Delete From A Where isok = 0
Delete B From A Inner Join B On A.id = B.id Where A.isok = 0
[解决办法]
delete b where id in (select hyid from a where isok=0)
delete a where isok=0
[解决办法]
Create Trigger Delete_B On A
For Delete
As
Delete B From Deleted A Inner Join B On A.id = B.id
GO
[解决办法]
delete b from a,b where A.hyid=B.id and a.isok=0
delete a where isok=0