[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