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
