DELETE FROM strategies

WHERE author_id IN

(SELECT officerid

FROM officers

WHERE officerFName = ‘jean-luc’

AND officerLName = ‘Picard’)

You can use subqueries to perform UPDATE or DELETE commands, however, this does increase the chance for Rogue results, to mitigate this consider the following 2 policies:

1) Always test Subqueries

2) Archive Data before Subquery DELETE

Evasive Maneuver – Picard 34Alpha

Using Subqueries In UPDATE or DELETE