How to find entries missing in 2nd table?

Поиск
Список
Период
Сортировка
От alex-lists-pgsql@yuriev.com
Тема How to find entries missing in 2nd table?
Дата
Msg-id 20060711141951.GA17936@s2.yuriev.com
обсуждение исходный текст
Ответы Re: How to find entries missing in 2nd table?  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: How to find entries missing in 2nd table?  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: How to find entries missing in 2nd table?  (Frank Bax <fbax@sympatico.ca>)
Список pgsql-sql
Hi,I realize I probably lost my marbles but I've been having a god
awful time with a single query:

control:........controller_id    pk;


datapack:
controller_id    fk;............

I need to get all entries from the table control that are not listed in
datapack.


Thanks,
Alex


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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: MS-SQL<->Postgres sync
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: How to find entries missing in 2nd table?