Carol,
Try this.
Select * From Table1 Where Street Name Not In(Select Street name From
Table2) Into Not_In_Table2
Then
Select * From Table2 Where StreetName Not In(Select Streetname From
Table1) Into Not_In_Table1
Both of these queries may take a long to process if your data sets are
large.
Also, if the records in the table can only be identified as unique by
combining the streetname with the zoneid then I would try populating a
new column with the combined value of these fields (you can use a query
to do this). Then you will have to perform select queries similar to
that above except that StreetName will be replaced by the name of the
combined field.
Keith
-----Original Message-----
From: Carol Crutchfield [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 27, 2000 3:39 PM
To: [EMAIL PROTECTED]
Subject: MI query help
I have 2 tables I need to compare.
Contained in each table are streets names and an associated zoneid.
In theory the 2 tables should contain identical information, but in the
real
world that are items in table1 that are not in table2, and vice versa. I
have tried to write query to compare table and output difference into
new
table with no luck. (I can output like items).
I have no programming background as you might guess from earlier
questions.
All help greatly appreciated.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
