Re: SQL query question

Hello,

What I want to know is which person in every society has made the more billing (and how much) between two dates.

So if I take your good examples the results will be:

 IDSOCIETY IDPEOPLE SUM(BILLING)
---------- ---------- ------------

        12         25      5001585.66
        10         12      1585.66
      2545      35847      9989.01

Regards,
Xavier Fabre Received on Mon Jul 23 2001 - 01:33:29 CDT