Thank you John,
That did the trick.
Gil
> -Original Message-
> From: John W. Holmes [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 16, 2004 9:46 PM
> To: mayo
> Cc: php-db
> Subject: Re: [PHP-DB] sql, grouping problem
>
>
> mayo wrote:
>
mayo wrote:
cold fusion allows you to group output (see below)
Select c.classId, c.classTexts, c.classDescription,
cc.classCodeSection, cc.classDate, cc.classTime,
cc.classLocation, cc.classInstructor
FROM CLASSES c, CLASSCODES cc
WHERE c.classId = cc.classId
AND ...
ORDER BY c.cla