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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
