Retriveng data from DB

In my DB I have the following things (tables)

  1. student
  2. course_students ( has two fields: status, and Student)
  3. courses ( has a list of course_students that includes all the students in the course, each with his status)
    what is the way to show all the courses of a given student ??