On Tuesday 16 November 2004 02:21, Ben Miller wrote: > That did it perfectly. Why don't any of the stupid books tell you that you > need the AS statement? You don't *need* the AS. You just need to be aware that without the AS the query will return a column called 'SUM(columnname)'. The AS is for convenience and not mandatory. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general ------------------------------------------ /* Earth -- mother of the most beautiful women in the universe. -- Apollo, "Who Mourns for Adonais?" stardate 3468.1 */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php