SQL Query Help - Return row in table which relates to another table row with max(column)
I have two tables:

    Table1 = Schools
        Columns: id(PK), state(nvchar(100)), schoolname

    Table2 = Grades
        Columns: id(PK), id_schools(FK), Year, Reading, Writing...

I would like to develop a query to find the schoolname which has the highest grade for Reading.

So far I have the following and need help to fill in the blanks:

    SELECT Schools.schoolname, Grades.Reading
    FROM Schools, Grades
    WHERE Schools.id = (* need id_schools for max(Grades.Reading)*)

SQL Query Help - Return row in table which relates to another table row with max(column)
===

I have two tables:

    Table1 = Schools
        Columns: id(PK), state(nvchar(100)), schoolname

    Table2 = Grades
        Columns: id(PK), id_schools(FK), Year, Reading, Writing...

I would like to develop a query to find the schoolname which has the highest grade for Reading.

So far I have the following and need help to fill in the blanks:

    SELECT Schools.schoolname, Grades.Reading
    FROM Schools, Grades
    WHERE Schools.id = (* need id_schools for max(Grades.Reading)*)
