Go4Expert (http://www.go4expert.com/)
-   Meet and Greet (http://www.go4expert.com/community/meet-and-greet/)
-   -   deletes with rowid (http://www.go4expert.com/community/deletes-with-rowid-t28134/)

rayliner 5Apr2012 01:24

deletes with rowid
i have a fairly complex query that ties in a lto of info from multiple tables to identify specific rows in a single table to delete.I figured the simplest was would be to create a select query that returns the rowid of the rows to be deleted and do something like this:delete from myFile ddwhere dd.rowid in (select d.rowidfrom myFile,myOtherfile where blah,blah)The SELECT by itself works fine, but it won't delete any rows in the statement above. I was able to delete the rows I wanted by running the select, copy/pasting the rowid's from the select into the delete statement (and add quotes and commas), and that worked fine.delete from myFile ddwhere dd.rowid in ('AAANXoAAIAABfK5AAP','AAANXoAAIAABfK5AAG','AAANXo AAIAABfK5AAI','AAANXoAAIAABfK5AAJ')Why wouldn't the delete with the embedded slect work?

All times are GMT +5.5. The time now is 07:16.