Hi Rick,
I actually fixed that problem - it was due to the fact that the GROUP BY and ORDER By
statement were
mixed up :(
still don't understand groups well, though :(
Thanks,
James Cox
----- Original Message -----
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'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-----
> 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 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
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
