query help

Discussion in 'Databases' started by decepti0n, Mar 31, 2008.

0
  1. #1
    How can I do this:

    - 2 Tables - guesses and games
    - guesses.movieid matches games.gid
    - I need the latest ten games, plus the latest matching guess

    SELECT * FROM `games` LEFT JOIN guesses ON games.gid = guesses.movieid GROUP BY gid order by `gid` desc
    Code (markup):
    Thats all i have so far and it semi works - it just doesn't get the latest guess, it gets the first one. Is there a way to order the guesses table descendingly? Would be good

    Thanks for any help
     
    decepti0n, Mar 31, 2008 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Remove GROUP BY
     
    mwasif, Mar 31, 2008 IP