7;James Cox'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 28, 2001 10:33 PM
Subject: RE: GROUP BY behaviour.. help needed..
> What response/results are you getting? Tt would help us to determine the
> problem
>
> -Original Message-
>
What response/results are you getting? Tt would help us to determine the
problem
-Original Message-
From: James Cox [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 7:13 AM
To: [EMAIL PROTECTED]
Subject: GROUP BY behaviour.. help needed..
Hello,
This is the following SQL
Hello,
This is the following SQL statement used in a results page for a search:
SELECT icaref, id, date, payee, descript, disb, payment, receipt-payment, receipt,
SUM(disb),
SUM(receipt-payment)
FROM data
WHERE receipt-payment > 0 AND date BETWEEN 'varStart' AND 'varEnd'
ORDER BY date
GROUP BY
