Re: [SLUG] mySQL delete problem.

[marty]

> delete FROM password WHERE password.uname IN
> (select uname FROM user WHERE status = "old");

try being explicit about the status field...

ie.

delete FROM password WHERE password.uname IN
(select uname FROM user WHERE user.status = "old");

later
marty

"I can't buy what I want because it's free. Can't be what they want
because I'm me." - Corduroy, Pearl Jam


-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://slug.org.au/lists/listinfo/slug