Re: [SQL] Finding missing records...

Поиск
Список
Период
Сортировка
От Sevo Stille
Тема Re: [SQL] Finding missing records...
Дата
Msg-id 38B6B00A.69D7F220@ip23.net
обсуждение исходный текст
Ответ на Finding missing records...  (Matthew Hagerty <matthew@venux.net>)
Список pgsql-sql
Matthew Hagerty wrote:
> happened.  Can someone demonstrate a query that would show all records in
> the primary table that do not have associated records in the secondary table?

EXCEPT. As in "select key from table1 except select key_ref from
table2;". 

Sevo


-- 
sevo@ip23.net


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