RE: Invalid syntax with STD() function when more than one field is used in select query

2006-07-21 Thread William Bronsema
006 10:18 AM > To: mysql@lists.mysql.com > Subject: Invalid syntax with STD() function when more than one field is > used in select query > > Hello, > > I am encountering a strange issue when using the STD function. On my > local development machine (MYSQL version 4.18-nt

Invalid syntax with STD() function when more than one field is used in select query

2006-07-20 Thread William Bronsema
Hello, I am encountering a strange issue when using the STD function. On my local development machine (MYSQL version 4.18-nt) I can run the following basic SELECT query with no problems: SELECT STD(`LAPSETIME`),UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP BY UKEY When I test this query on m