Hi Andrew, A sub-select query is your best bet:
Select * From Table_1 Where Table_1.ID not in (Select Table_2.ID from Table_2) Into Not_Matched This will select all records in Table_1 that do not have a match in Table_2 into a temp table Not_Matched. Cheers, Peter Zyczynski Analyst Programmer Insight GIS Australia Ph: (03) 6234-5833 Fax: (03) 6234-5899 [EMAIL PROTECTED] www.insightgis.com.au -----Original Message----- From: Canfield, Andrew [mailto:ACanfield@;broadband.att.com] Sent: Thursday, 14 November 2002 9:58 AM To: '[EMAIL PROTECTED]' Subject: MI-L Query question I have two tables Table one is only a browser table it has no graphical data. Table two has all the same column names but also has graphical data. One polygon for each record. I have a primary key that is an ID number in both tables. How do I run a query that will give me all the records in my Non-graphical table where the ID number doesn't exsist in my other table? Basically I want all the records which haven't been drafted yet because the drafters fill in the ID number field as they draft. I need to see how many lots are not yet drafted. Thanks in Advance, Andy --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4096
