Thanks to everyone who replied.
If anyone else is interested the solution was the following...
Select * from database1
Where ID not in (select ID FROM database2)
---------------------- Forwarded by Dan Page/HullOttawa/PCH/CA on 03/13/2000
03:17 PM ---------------------------
Dan Page
03/13/2000 11:58 AM
To: [EMAIL PROTECTED]
cc:
Subject: Selecting records
This is probably a very simple query. I have two databases in which each
database contains a common key field (ID number). However there are some records
that are in one database that are not in the other database. What I want to do
is select all the records (using the key field) from Database1 that DO NOT exist
in Database2. I tried the "NOT LIKE" function but doesn't seem to work. Is
there an operator that will do something like this....database1.ID not equal
database2.ID
TIA
Dan
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
