using COUNT and retrieve field in same query

Hi,

 Ihave been trying to do a count and retrieve a field from within the same query:

SELECT field1, count(field2) FROM table1 WHERE field3=1;

but I always get the following error:

not a single-group group function

what am I doing wrong? is this possible at all to do?

thanks

Oliver Received on Mon Jan 19 2004 - 16:22:35 CST