Finding missing records...

Поиск
Список
Период
Сортировка
От Matthew Hagerty
Тема Finding missing records...
Дата
Msg-id 4.2.2.20000225105014.00ba6bf0@mail.venux.net
обсуждение исходный текст
Ответы Re: [SQL] Finding missing records...  (wieck@debis.com (Jan Wieck))
Список pgsql-sql
Greetings,

I have two tables that maintain a 1:1 relationship via an int based primary 
key.  A record in the primary table should never exist without an 
associated record in the secondary table, however somehow this has 
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?

Thanks,
Matthew



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

Предыдущее
От: Alessio Bragadini
Дата:
Сообщение: Re: [SQL] INSERT w/o variable names for a SERIAL type?
Следующее
От: wieck@debis.com (Jan Wieck)
Дата:
Сообщение: Re: [SQL] Finding missing records...