subquery
| From: | Brock Jimmy D Contr 74MDSS/SGSI | Date: | Fri, 28 May 2004 18:45:04 +0000 |
| Subject: | subquery | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34576@lists.php.net to get a copy of this message | ||
I'm trying to use a delete subquery in Oracle (using SQL) and it is preventing me from deleting
when no records are found in the SELECT statement.
DELETE roles WHERE roleid NOT IN (SELECT DISTINCT roleid FROM users WHERE roleid='Staff
Member';
There are no records in the USERS table that has a roleid='Staff Members'
Any suggestions?
Jimmy Brock
Web Developer