[PHP-DB] subquery

[Brock Jimmy D Contr 74MDSS/SGSI]

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