In message <[EMAIL PROTECTED]>, Kevin J. Bowman <[EMAIL PROTECTED]> writes >SELECT customers.name,date,code FROM customers, (SELECT name,max(date) >AS maxdate FROM customers GROUP BY name) AS maxdates WHERE >customers.name=maxdates.name AND date=maxdate;
Subselects have been introduced in a recent version of MySQL, I don't know which. I wonder if your version is too old for this syntax? -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
