Finding missing records...

Поиск
Список
Период
Сортировка
От Matthew Hagerty
Тема Finding missing records...
Дата
Msg-id 4.2.2.20000225105014.00ba6bf0@mail.venux.net
обсуждение исходный текст
Ответы Re: [SQL] Finding missing records...
Список 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 по дате отправления: