I thought the rule was that fields in a select statement with a group by had to either be in the group by or be an aggregate function, e.g
select a, b, count(*) from some_table group by a should be an error. If not what value does the "b" field have? Vince Thomas
