Assignment.find(:all, :join => "LEFT JOIN courses ON courses.id = assignments.course_id
                                LEFT JOIN courses_teachers AS ca ON courses.id = ca.course_id",
                      :conditions => [ "ca.teacher_id = ?", @TeacherInstance.id ] )