Lost connection to Mysql server during query using a group by clause and sub query

[Dan Rossi]

Hi there, I am having issues with this funny error message. I am trying 
to do a sub query and then a group by clause on a date. However i keep 
getting this annoying message for some reason. Happens via terminal 
aswell as my sql gui.  Here is the query I am trying to do

select (select count(discrepancy_originID) FROM report_log WHERE 
discrepancy_originID=1) as total FROM report_log GROUP BY MONTH 
(tx_date)

let me know, if i take the sub query out its ok ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]