Hi, try doing
Delete from Selection after you have made your selection. ie. (where Key is a column in table1 and table2) Select * from table1 Where Key In (Select Key from table2) Delete from Selection - Sam -----Original Message----- From: Terrence O'Neill [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 3:29 PM To: 'Mapinfo' Subject: MI-L Deleting selection One quick question. The answers probably something simple, however, it has been eluding me. Once you've used the select statement in MapBasic to select certain rows from a table, how do you delete them from the table?? "Delete From" wipes out all from the table, you can't use a where clause unless you have the rowid, and I even tried "delete selection from" and, of course, that didn't work either. Someone please(!) give me a clue. Terry _______________________________________________________________________ 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.
