There is another solution which I forgot to mention. select * from Table1 where Col1 not in (select Col1 from Table2) and Col2 not in (select Col2 from Table2) into Selection
The reason I don't use this is because MapInfo handles these kind of queries so inefficiently, that when dealing with tables of several thousand records, the query takes ages (like an hour or more). I think this would be okay if your tables had a few hundred or less records. Cheers again, Simon -------------------------------------------- Simon O'Keefe Groundtruth GIS Australia _______________________________________________________________________ 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.
