SQL语句

SQL

删除Approval表中在SchemeOverall表里已经删除的主信息（TargetId为int类型，没有关联）

delete [Approval] from [Approval] left join [SchemeOverall] on [Approval].TargetId=[SchemeOverall].OID
where [Approval].Type='SchemeOverall' and [SchemeOverall].OID is null