Re: [SQL] howto delete using a join ?

[Dmitriy Igrishin]

Hey Andreas,

You may want to use the USING clause:

DELETE FROM events USING event_types
  WHERE events.event_type_fk = event_types.event_type.id
  AND relevance_level IN ( 1, 3, 5, 7)
  AND <ANY_ANOTHER_CONDITION_YOU_
NEED> ;

Regards,
Dmitriy