Hi Have you tried: Select * from build where Baappln in (select baappln from applist) into mytab Delete from mytab
Give that a go - should do what you want. You have made a join between 2 tables and that creates a VIEW not another query table. You can delete from a query table using the SQL method above. HTH (hope that helps!) regards Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Slaven Blake Sent: 22 October 2001 02:59 To: Mapinfo Mailing List (E-mail) Subject: MI-L Mapbasic question Hey Listers, I've never been good at writing code so I'm hoping someone out there can help me. I have a table with a list of building applications that I want deleted from the main building applications table. But when I run a simple select query in mapbasic selecting all records in the main table that have a corresponding app number with my list then try to delete all records in the result query I get a message saying "Cannot delete from view". I can do all this in MI with no dramas but its got me stumped why its stuffing up in MB. This is what I've written that is causing the error message: Select Build.Baappln, Build.Pid, Build.Lotplan, Build.Location, Build.Suburb, Build.Type, Build.Class, Build.Recd from Build, AppList where Build.Baappln=AppList.Baappln into temp Delete from temp Any help will be appreciated. Cheers, Blake Slaven GIS Officer - Information Technology Burnett Shire Council Locked Bag 1 Bargara 4670 [EMAIL PROTECTED] ph: +61 (07) 4150 5504 fax: +61 (07) 4150 5410 This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the originator of the message. This footer also confirms that this email message has been scanned for the presence of computer viruses Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Burnett Shire Council. _______________________________________________________________________ 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.
