|
Posted by germanshorthairpointer@gmail.com on 10/02/65 11:50
Hello,
I'm trying to do a join based on the following tables:
Person(person_id,person_name)
Grade(grade_id,grade_person_id,grade_score)
The data looks like this:
Person:
1,John
2,Dave
Grade:
1,1,80
2,1,90
3,2,60
4,2,70
I'd like a query that returns the each persons name along with their
highest grade.
What would the query be?
Thanks!
Navigation:
[Reply to this message]
|