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 disb, receipt-payment
why does it not work?
and can someone help me understand groups better ?
Thanks,
James Cox
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
