G'day all, Is it possible to use a query as a source for another query? For example...
Query 1: SELECT COUNT(*) AS TotalSurveys, SurveyDate FROM Surveys GROUP BY SurveyDate; Query 2: SELECT MIN(TotalSurveys) AS MinSurveys, MAX(TotalSurveys) AS MaxSurveys FROM <Query 1>; I am using 3.23.53 on a Windows 2000 (SP3) platform. Adrian [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php