GROUP BY gives me a "column invalid because..." error

[jt-developer]

Hi all, I'm using GROUP By in my SQL statement im using (with PSP and mssql), so that records aren't repeated, when I test it I get :

Warning: mssql_query(): message: Column 'PAYG.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. (severity 16)...

the id column is an int, and it repeats this error for every column, which vary from ints to chars.

any ideas?

cheers all

[devinemke]

and the exact query is?...

[jt-developer]

oh oits ok i figured it, I had "select *" instead of select id, blah, blah etc etc