ข่วยดู code search menu/list การ join ตารางด้วยครับ

<?
session_start();
include "chksession.php";
$scholar_degree = $_POST['scholar_degree'];
$scholar_academic_year = $_POST['scholar_academic_year'];
$school_type_id = $_POST['school_type_id'];
$status = $_POST['status'];

include("config.inc.php");
$sql = "select scholar_degree.r,scholar_academic_year.r,School_type_id.d,Status_ID.d
			   from scholar_school_record1 r,scholar_data d
			   where scholar_id.r = Scholar_ID.d and scholar_degree.r LIKE '%".$scholar_degree."%' or scholar_academic_year.r LIKE 
			   '%".$scholar_academic_year."%' or School_type_id.d LIKE '%".$School_type_id."%' or Status_ID.d LIKE '%".$Status_ID."%' ";
			   
while($arr=mysql_fetch_array($sql)){
		$scholar_degree=$arr['scholar_degree'];
		$scholar_academic_year=$arr['scholar_academic_year'];	
		$school_type_id =$arr['School_type_id'];
		$status =$arr['Status_ID'];
		

}
?>