Could you specify the error in more detail? Thnks, Carl
Kevin J. Bowman wrote: > Carl, > > So I setup a test database using your parameters. I input your query > > 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; > > and the database returned a bad syntax error code. My ISP uses 4.0.22 > Standard of MySql > > Kevin > > > > > 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] > <mailto:[EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > [Non-text portions of this message have been removed] 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/
