DELETE FROM roles
WHERE roleid NOT IN ( SELECT DISTINCT roleid FROM users);
Rui
Chris Bolt writes:
How about:
DELETE FROM users WHERE userid IN (SELECT u.userid FROM users AS u
LEFT JOIN roles AS r ON (u.roleid = r.roleid) WHERE r.roleid IS NULL
LIMIT 1);
On Mon, 14 Jun 2004 11:59:25 -0400, Brock Jimmy D Contr 74 MDSS/SGSI <jimmy.brock@xxxxxxxxxxxx> wrote:
I've been able to figure how to use a delete subquery to delete all rows, but how do I use a delete subquery to delete only one row?
I have two tables: users and roles with the following fields:
Users:
userid
roleid
Roles:
roleid
I want to be able to delete a rowid from the roles table, but only if the roleid does not exist in the users table.
thanks
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
