howto delete using a join ?

Поиск
Список
Период
Сортировка
Искать

howto delete using a join ?

От:
Andreas <maps.on@gmx.net>
Дата:

Re: howto delete using a join ?

От:
Joshua Tolley <eggyknap@gmail.com>
Дата:

Re: howto delete using a join ?

От:
Dmitriy Igrishin <dmitigr@gmail.com>
Дата:
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

FAQ