คือ join ข้อมูล 3 ตารางนะครับ คือ join อย่างไงก็ไม่ได้ ช่วยหน่อยนะครับ

<?

$scholar_degree = $_POST['scholar_degree'];
$scholar_academic_year = trim($_POST['scholar_academic_year']);
$school_type = $_POST['school_type'];
$scholar_status = $_POST['scholar_status'];

include("config.inc.php");
$sql = "select d.School_type_id,s.Status_Detail,r.scholar_degree,r.scholar_academic_year
FROM scholar_data d, status s, scholar_school_record1 r
where d.Status_ID = s.Status_ID AND  d.Scholar_ID = r.school_id AND 
       r.scholar_degree LIKE '%($scholar_degree)%' AND r.scholar_academic_year LIKE '%($scholar_academic_year)%' AND
	   d.school_type_id LIKE '%($school_type)%' s.Status_Detail LIKE '%($school_type)%'";  
	   
$result = mysql_query($sql) or die("error=$sql");
while ($rows = mysql_fetch_array($result)) {
$i++;
$scholar_degree = $rows["scholar_degree"];
$scholar_academic_year = $rows["scholar_academic_year"];
$school_type = $rows["School_type_id"];
$scholar_status = $rows["Status_ID"];
}

?>