subject:"GROUP by multiple columns \[id\:fns\]"

RE: GROUP by multiple columns [id:fns]

2002-03-12 Thread Roger Karnouk

ssage- From: Gabor PENOFF [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 11:59 AM To: [EMAIL PROTECTED] Subject: GROUP by multiple columns [id:fns] Hi folks, I need a select groupped by more than one field like: SELECT a, b, c, SUM(d) FROM a GROUP BY CONCAT(a,b) - but it doesn&#

GROUP by multiple columns [id:fns]

2002-03-12 Thread Gabor PENOFF

Hi folks, I need a select groupped by more than one field like: SELECT a, b, c, SUM(d) FROM a GROUP BY CONCAT(a,b) - but it doesn't work (MySQL 3.22). Is it poissible somehow? cu, fns -[ mailto:[EMAIL PROTECTED] http://www.megaram.hu/~fns icq:878397 ]- -[ Zavart erzek az eroben.