howto delete using a join ?
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_
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
Regards,
Dmitriy