Novice needs help
От | Terry Lee Tucker |
---|---|
Тема | Novice needs help |
Дата | |
Msg-id | 3E6E2139.5060903@esc1.com обсуждение исходный текст |
Ответы |
Re: Novice needs help
Re: Novice needs help |
Список | pgsql-sql |
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? Here is the partial table layout: cust province -------- ------- country ===> country province ===> code Thanks in advance... -- Terry Lee Tucker
В списке pgsql-sql по дате отправления: