Hi
with the following query:
select jobno, count(jobno) from drawing_register;
I get the following error:
ERROR: Attribute drawing_register.jobno must be GROUPed or used in an
aggregate function
Is this correct? Getting rid of the error is easy:
select jobno, count(jobno) from drawing_register group by jobno;
I believe that jobno is being used in an aggregate function. Should a
change be made to the error text?
Regards
Joe Healy