Message-ID: <3E6E2139.5060903@esc1.com>
Date: Tue, 11 Mar 2003 12:47:37 -0500
From: Terry Lee Tucker <terry@esc1.com>
Organization: Enhanced Solutions Computing
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.0.2) Gecko/20021120 Netscape/7.01
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Novice needs help
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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