Hello,
MySQL version 4.0.20
I'm trying to figure out, if it's possible to do, with one query to update a single table.
Query #1 select m.memid from members m left join active a on a.memid = m.memid where a.acct_days > 0 and m.account = 1;
Query # 2 update members set account = 2 where memid in (results from query #1)
Can this all be done in one sql statement, in query 2?
TIA
Mickalo
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
