[thelist] SQL - Invalid use of group function

Lauri Vain optima at hot.ee
Thu Aug 16 06:30:27 CDT 2001


Hi all,

I have a problem with SQL  :(

The query:
"SELECT kandmed.nimi nimi,
kandmed.id id,
ROUND(AVG(personalia_comments.hinne),2) hinne,
ROUND(AVG(personalia_fees.hinne),2) fee,
personalia_skills.php php,
personalia_skills.sql sql,
personalia_skills.disain disain
FROM kandmed,
personalia_user,
personalia_skills,
personalia_comments,
personalia_fees
WHERE kandmed.id = personalia_user.uid &&
kandmed.id = personalia_skills.uid &&
kandmed.id = personalia_comments.uid &&
kandmed.id = personalia_fees.uid &&
AVG(personalia_fees.hinne) >= '1'
GROUP BY personalia_comments.uid,
personalia_fees.uid"

MySQL said: Invalid use of group function

I started to get the error by adding "AVG(personalia_fees.hinne) >= '1' "

Any ideas?

The table "kandmed" is used to store user data (names and such).
The tables "personalia_fees" and "personalia_comments" have several rows per one
user. I need the average of the "hinne" column. The rows are tied to the user by
the column "uid" (user id).

Thanks!

Yours,
Lauri





More information about the thelist mailing list