Just recently post a problem on how can i see all max(dateposted) on all of my records by doing this..
select datacount,office,filename,status, max(dateposted) from dCOPY group by office; now, i was wondering if i can use max() on update to update all my current records only.. i tried this: mysql> update dCOPY set status = '1' where max(dateposted); ERROR 1111: Invalid use of group function mysql> But as you can see, it returns an error for an invalid group function. -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
