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]