sql - Getting result from db using WHERE ALL -

him need writing sql sql query. example have 2 tables. students , marks.

first table consist of student_id ,name,address, phone ....

second table include such columns : mark_id,student_id, subject_id , mark_value , date

so need information students have marks of 1 type (for instance or c). example student stuart has got 5 marks , of them need information student.

i must use or statement.

please explain how this. in advance.

assuming mysql.

 select * student s  <grade > = ( select mark_value marks m m.student_id = s.student_id )

UIO