postegresql delete
snippet in sql

postegresql delete

user5316

DELETE FROM films
  WHERE producer_id IN (SELECT id FROM producers WHERE name = 'foo');