How to write a join query with multiple fields equal?

[xuxcwk]

For example I have 2 tables：
class(
id int not null,
school varchar(32),
name varchar(32),
)

student（
id int not null,
name varchar(32),
class_id int,
school varchar(32),
）

I want to select like this:
select s.name,c.name from student s left join class c on s.class_id = c.id and s.school = c.school where s.id = 10;
How should I write Relation and queries?