Report that shows top score of each game
I'm currently making a database based around an internet cafe. I'm at the stage where I need to be able to produce a report showing the top score for each game available.
Currently I have a Member table with a primary key of Member ID
Software table with a primary of Software ID
Member game table - with Software ID, Member ID, Score,
I've been looking up top line queries(?) but I'm not sure this is the way I should be looking to do this?
any help is appriciated.