Re: Aggregating function which returns more than one row

2002-12-05 Thread Felix LUNGU
ictor Pendleton wrote: > Felix, > Can you please give an example of what you are attempting to do? > > -Original Message----- > From: Felix LUNGU [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 9:22 AM > To: [EMAIL PROTECTED] > Subject: Aggregating functio

Re: Aggregating function which returns more than one row

2002-12-05 Thread Felix LUNGU
No. It is not what I want. This is a normal aggregation. The sum function will be called once for each group (SalespersonNm) and it will return one row. What I have asked is : if I have 10 rows, can I return 12? It's rude, but that's the idea. Thanks, Felix DL Neil wrote: > Felix, > > > Is is

Aggregating function which returns more than one row

2002-12-04 Thread Felix LUNGU
Is is it possible to write an aggregation function which returns more than one row? Thanks, felix Mysql sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/