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
<[EMAIL PROTECTED]> wrote:
>
> I've been able to figure how to use a d
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 role