Re: Issue with AS and sub queries

2005-07-10 Thread Gleb Paharenko
Hello. Please can you send the complete query and table definition, because I was unable to reproduce this weird behavior. What version of MySQL do you use? What client do you use to execute queries? We can see below, that there is no period before total_bandwidth: mysql> select (SELECT S

Issue with AS and sub queries

2005-07-07 Thread Dan Rossi
Hi there somehow my AS field alias of a sub query is adding a dot at the start therefore I cant use it in my application. (SELECT SUM(feed_usage.bandwidth) AS bandwidth FROM feed_usage WHERE customerID IN (57) AND DATE_FORMAT(feed_usage.stats_date,'%m%Y')=DATE_FORMAT(NOW(),'%m%Y') ) AS total_