Delete across 5 Joined tables

Поиск
Список
Период
Сортировка
От Fuzzygoth
Тема Delete across 5 Joined tables
Дата
Msg-id 2bc56296-2b46-49e1-bc46-f51f92813276@d1g2000hsg.googlegroups.com
обсуждение исходный текст
Ответы Re: Delete across 5 Joined tables  (Raymond O'Donnell <rod@iol.ie>)
Список pgsql-general
Hi,
I am trying to delete a set of related record across the whole
database, In tests I
have managed to delete records from 2 tables using the code below.

DELETE FROM phillipsd.tablea using phillipsd.tableb WHERE tablea.one =
2;

but I need to be able to delete from up to 5 different tables, is
there a quick and
simple way of doing this? can someone post an example?

Cheers
David P

В списке pgsql-general по дате отправления:

Предыдущее
От: Nick
Дата:
Сообщение: Re: Incorrect results with NOT IN
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Windows Installation Problem