How to write a SQL DELETE statement with a SELECT statement in ...

2013年7月9日 - in this scenario: DELETE FROM tableA WHERE (SELECT q.entitynum FROM tableA q INNER JOIN tableB u on (u.qlabel = q.entityrole AND ...

stackoverflow.com