Cacher is the code snippet organizer for pro developers

-- SQL Delete based on condition in join
-- http://stackoverflow.com/questions/4097260/sql-delete-based-on-condition-in-join

DELETE A
FROM TableA AS A 
  LEFT OUTER JOIN TableB As B ON A.TableAId = B.TableBId 
WHERE B.Column IS NULL