Simple Query giving error message... help please? (1 Viewer)

[killyridols]

Hi,

When I try to run this simple query:

SELECT sample_id, sum(data) AS summe
FROM REVDAT;

I get an error message that says,
"You tried to execute a query that does not include the specified expression 'sample_id' as part of an aggregate function"

Does anyone know what would cause this error?
I have no idea....

Thank you!

 

[ByteMyzer]

You need to include a GROUP BY clause, thus:

SELECT sample_id, sum(data) AS summe
FROM REVDAT
[B][I][COLOR=red]GROUP BY sample_id[/COLOR][/I][/B];

 

[killyridols]

thanks, ya sorry, I ended up realizing that right after i posted that.
Sorry for taking up unnecessary space on the board!