Newsgroups: comp.databases.theory From: Aloha Kakuikanu References: <%zFI6.1690$vg1.141759@www.newsranger.com> <3af34a5d$0$14444$1dc6e903@news.corecomm.net> Subject: Re: is concat a group by function? Lines: 30 Message-ID: X-Abuse-Info: When contacting newsranger.com regarding abuse please X-Abuse-Info: forward the entire news article including headers or X-Abuse-Info: else we will not be able to process your request X-Complaints-To: abuse@newsranger.com NNTP-Posting-Date: Fri, 04 May 2001 21:09:26 EDT Organization: http://www.newsranger.com Date: Sat, 05 May 2001 01:09:26 GMT In article <3af34a5d$0$14444$1dc6e903@news.corecomm.net>, Carlos Bromanski says... > >Do what? Please describe what result you're trying to get. >CONCAT is not an aggregate function. (not in Chicago, anyway) The query is supposed to return: MGR EMP ------ -------- Newton Gauss, Hilbert Euclid Einstein >Aloha Kakuikanu wrote in message >news:%zFI6.1690$vg1.141759@www.newsranger.com... >> SELECT >> MGR, >> CONCAT( EMPNO ) || ',' >> FROM SCOTT.EMP >> group by MGR >> >> doesn't work, of course. Any other way to do it? >> >> >> > >