To find records in one table ("Table_B") that do not exist in another table
("Table_A"), use the following:
Select * From Table_B
Where Table_B.PID Not In(Select PID From Table_A)
This will work in both the SQL dialog and the MB window.
I ran this with a 200 record Table_B against a 200000 record Table_A, and it
took about 30 minutes, but it does work.
This is also in the manual, but (probably due to fat-finger syndrome), it
had not worked previously.
Thanks to all who responded.
Gerald Kornelsen
GIS Technologist
City of Winnipeg
Property Assessment Department
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
