2008/10/17 Brent Baisley <[EMAIL PROTECTED]>: > Why are you creating a subquery/derived table? > > Just change your limit to 1,2 > ORDER BY updates.AcctSessionTime DESC LIMIT 1,2
Because then the maths in the select part isn't executed, and I don't get the figures I need. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]