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
