Oliver Jowett schrieb:
> Try COUNT(distinct REGISTER.pd.pdkz) perhaps
Hi!
SELECT COUNT(DISTINCT REGISTER.pd.pdkz)
FROM REGISTER.pd JOIN
REGISTER.vornamen ON REGISTER.vornamen.pdkz = REGISTER.pd.pdkz
works, but with that of cource I don't get the data, just the amount of
rows, so I would have to call it another time without COUNT to get the data.
A query like that
SELECT COUNT(DISTINCT REGISTER.pd.pdkz), DISTINCT REGISTER.pd.pdkz
FROM REGISTER.pd JOIN
REGISTER.vornamen ON REGISTER.vornamen.pdkz = REGISTER.pd.pdkz
gives the same mentioned error: column "pd.pdkz" must appear in the
GROUP BY clause or be used in an aggregate function
Any ideas anyone?