Subject Why won't Group By work?
Author Adrian Wreyford
I have a table Rainfall with fields:

Rainfallid

RainfallZone

Rainfall

RainfallDate



Select * from Rainfall

Group by Rainfallzone



Get Error:

Invalid expression in the select list(Not contained in either an aggregate
function or group by clause)



Thanks Adrian





[Non-text portions of this message have been removed]