public static function retrieveByStudentApprovedCourseSubject(StudentApprovedCourseSubject $approved_result, PropelPDO $con = null)
{
$con = is_null($con) ? Propel::getConnection() : $con;
$c = new Criteria();
$c->addJoin(CourseSubjectStudentPeer::ID, StudentDisapprovedCourseSubjectPeer::COURSE_SUBJECT_STUDENT_ID);
$c->add(CourseSubjectStudentPeer::COURSE_SUBJECT_ID, $approved_result->getCourseSubjectId());
$c->add(CourseSubjectStudentPeer::STUDENT_ID, $approved_result->getStudentId());
$c->add(StudentDisapprovedCourseSubjectPeer::STUDENT_APPROVED_CAREER_SUBJECT_ID, null, Criteria::ISNULL);
return self::doSelectOne($c, $con);
}
