ok, just removed the distinct syntax On Mon, 26 Jul 2004 23:51:43 -0500, mos <[EMAIL PROTECTED]> wrote: > At 10:45 PM 7/26/2004, you wrote: > >if I understand you correctly, this should do it. > > > >select distinct office, max(dateposted) > >from table > >group by office > > > Just one more thing. You don't need "distinct" because you are already > using "group by". > > Mike > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
-- Louie Miranda http://www.axishift.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
