Re: Novice needs help
От | jasiek@klaster.net |
---|---|
Тема | Re: Novice needs help |
Дата | |
Msg-id | 20030311210320.GA4634@serwer обсуждение исходный текст |
Ответ на | Novice needs help (Terry Lee Tucker <terry@esc1.com>) |
Список | pgsql-sql |
On Tue, Mar 11, 2003 at 12:47:37PM -0500, Terry Lee Tucker wrote: > I have loaded over 29,000 customer records into a database. I'm trying > to apply a referential foreign key that validates the country code and > the province code in another table. It won't work because somewhere in > that 29,000 records there is a province code or country code that > doesn't match. Is there a way to use a select statement to find out > which customer records has the invalid data? Yes. Here is the partial table > layout: > > cust province > -------- ------- > country ===> country > province ===> code You didn't notice howw exactly your relation works. Is it: cust.country=province.country and cust.province=province.code ? If yes, try this: select c.country,c.province from cust c left join province p on (c.country=p.country and c.province=p.code) where p.country is null or p.code is null; Regards, Tomasz Myrta
В списке pgsql-sql по дате отправления: