>> Just one other tiny point of style here: having given the expression >> date(solarAWDateTime) the alias uniqueDate, you should probably use >> that alias to refer to the same thing elsewhere in your query, such as >> in the GROUP BY column. So: [8<] > That's a mysqlism :( It's not portable to other db's (apparently it's > not part of the sql-spec). I think I've even seen MySQL reject it in some cases. Ben -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php