I am SELECTing several fields and want to group by 3 of the fields. However it requires me to include all fields in the group by clause.

Why is this ??? Why can't you select a couple fields to group by like in crystal reports ?

Am I doing something wrong ?