A:id hyid hynumber isok
123 123 1001 0
133 135 1002 1B:id hyname
123 李
135 陈(注:A.hyid=B.id)如何删除A表里isok=0的那条数据,并删除B表中关联的数据?谢谢~~~
123 123 1001 0
133 135 1002 1B:id hyname
123 李
135 陈(注:A.hyid=B.id)如何删除A表里isok=0的那条数据,并删除B表中关联的数据?谢谢~~~
Delete B From A Inner Join B On A.id = B.id Where A.isok = 0
delete a where isok=0
For Delete
As
Delete B From Deleted A Inner Join B On A.id = B.id
GO
delete a where isok=0