Hi David, can't give you detailed advice but I believe you look for
SELECT...GROUP BY ... ORDER BY Please see the docs like "info mysql". Best regards Nils Valentin Tokyo/Japan \ 2003年 6月 4日 水曜日 22:37、Dave Terrio さんは書きました: > Hello - I'm a relative newcomer to development with MySQL and am having a > problem with ordering my query results... > > I first want to select the 50 most recently created records (with respect > to my date field) and then order these with respect to another field (eg > name). That way I'm always "ordering" the 50 most recent records. The > problem is, I can't figure out how to do this - as MYSQl complains when I > put 2 "ORDER BY" statements in a query such as in: > > order by table1.time_created desc limit 50 order by table1.name; > > Any suggestions? > > Thanks, > -David -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp ================================================ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]