Results 1 to 4 of 4

Thread: Invalid Use Of Group Function

Threaded View

  1. Mar 30th, 2008, 10:50 AM #1
    Pino
    Pino is offline

    Thread Starter
    PowerPoster
    Join Date
    Dec 2003
    Posts
    4,787

    Invalid Use Of Group Function

    Can anyone offer a solution?

    Code:
    SQL query: Documentation

SELECT tblscorerel.scoreid, tblscores.id, sum( tblscores.score )
FROM tblscorerel
INNER JOIN tblscores ON tblscorerel.scoreid = tblscores.id
ORDER BY sum( tblscores.score )

MySQL said: Documentation
#1111 - Invalid use of group function
    Side note, this works in MySql 5. But my host will not upgrade my client to version 5 so I'm stuck on 4. Can anyone offer a work around?
    Last edited by Pino; Mar 30th, 2008 at 11:21 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width