This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.
Thanks to all you responded, The NOT IN Clause works great! -----Original Message----- From: Fast, Tim [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:13 PM To: 'Morrier, Steve'; MapInfo-L (E-mail) Subject: RE: MI-L SQL Help Steve, Not to worry, you won't get fired. Remember we are the ones who actually do the work! Here is a method for selecting records in one table that do not match records in another table. Consider a situation where we must find all the records in TableA whose values in FieldA do not match the values of FieldB of records in TableB. Fill out the first 3 fields in the SQL Select Dialog box: Select Columns: * from Tables: TableA where Condition: NOT FieldA IN(SELECT FieldB FROM TableB) Hope this helps Tim Fast Pioneer Hi-Bred International -----Original Message----- From: Morrier, Steve [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:13 AM To: '[EMAIL PROTECTED]' Subject: MI-L SQL Help This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, I have what I thought would be an easy query but it is giving me problems. I have 2 street files, one new and one old. They have roughly the same structure with the old table having a few extra columns of data at the end. I would simply like to run a query to determine what Street Names exists in the new file that are not in the old file, or visa versa. I thought I could run a Where: New.Street_name <> Old.Street_name but this isn't working, I get an INVALID JOIN Clause error. If I swap the <> with = in hopes to invert the selection I get a table with 10 times the amount of records of the originals but no JOIN error. What am I doing wrong? Thanks for all your help, if it wasn't for this list I think I would have been fired years ago!! ;-) Steve _______________________________________________________________________ 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. _______________________________________________________________________ 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.