On Sun, 4 Dec 2005, Joost Kraaijeveld wrote: > Hi, > > I want the number of customers that have a zipCode smaller tha a given > value. The foolowing query doe snot work : I get an error (ERROR: > column "addresses.zipcode" must appear in the GROUP BY clause or be used > in an aggregate function) and I do not know how to solve it. > > SELECT COUNT(customers.objectid) FROM prototype.customers, > prototype.addresses > WHERE > customers.contactaddress = addresses.objectid > AND > zipCode < '2716BN' > ORDER By zipCode, houseNumber > > Anyone an idea?
In a non-grouped query like the above, I don't think that the order by is meaningful. You only get one row back anyway without a group by, and there's no single zipCode or houseNumber to associate with the row. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
