Re: ERROR 1111 (HY000): Invalid use of group function

2005-05-11 Thread Michael Stassen
WHERE CSV_File = 'ICS' -> AND CHAR_LENGTH(PRACT_NUMBER) > 4 -> AND COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > 1 -> AND Booking_ID = 6030 -> GROUP BY PRACT_NUMBER; ERROR (HY000): Invalid use of group function mysql> Can anyone tell me why this is happening? B

Re: ERROR 1111 (HY000): Invalid use of group function

2005-05-11 Thread Stefan Kuhn
mysql> SELECT PRACT_NUMBER, > -> COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > -> FROM CSV_Upload_Data > -> WHERE CSV_File = 'ICS' > -> AND CHAR_LENGTH(PRACT_NUMBER) > 4 > -> AND COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > 1 > -> AND Book

Re: ERROR 1111 (HY000): Invalid use of group function

2005-05-11 Thread Paul DuBois
'ICS' -> AND CHAR_LENGTH(PRACT_NUMBER) > 4 -> AND COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > 1 -> AND Booking_ID = 6030 -> GROUP BY PRACT_NUMBER; ERROR (HY000): Invalid use of group function mysql> Can anyone tell me why this is happening? Because you ca

ERROR 1111 (HY000): Invalid use of group function

2005-05-11 Thread shaun thornburgh
_NUMBER) > 4 -> AND COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > 1 -> AND Booking_ID = 6030 -> GROUP BY PRACT_NUMBER; ERROR (HY000): Invalid use of group function mysql> Can anyone tell me why this is happening? Thanks for your advice -- MySQL General Mailing List For