Hey all... I am trying to make a selection of records that don't match in 2 tables.
Select * from table1, table2 where table1.col1 = table2.col1 and table1.col2 = table2.col2 into Selection this works...but how do I get the inverse? If you replace the = with <> the tables cannot join and the sql falls flat. If I add a third column that does match...the sql runs but doesn't match... Select * from CWS, WO where CWS.Scheme_Location = WO.Scheme_Title and (CWS.SWR <> WO.SWR and CWS.Swr_sub <> Wo.swr_sub) into InvertSelection anyone know how to write invert selection code in mapbasic? Thanx Ben __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com _______________________________________________________________________ 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.
