>You could use a temporary table for that: >CREATE TEMPORARY TABLE tmp ( > deptID INT NOT NULL, > appSeq INT NOT NULL >) AS >SELECT deptID, max(appSeq) AS appSeq >FROM approvers >GROUP BY deptID; > >UPDATE approvers, tmp >SET approvers.appName = 'Sting Ray' >WHERE approvers.appName = 'Joe Bass' > AND approvers.deptID = tmp.deptID > AND approvers.appSeq = tmp.appSeq >;
Thanks! It's funny sometimes how these things seem so obvious --- AFTER somebody's shown the way! Randolph "Randy" L. Chrismon [EMAIL PROTECTED] Ph. 732-452-7610 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
