ยังงี้น่าจะได้นะครับ ผมไม่แน่ใจตรงตาราง department เลยใช้ query แยกกัน
Code (PHP)
$strSQL = "Select * from daily_report inner join member on (member.id_member = daily_report.id_member) inner join subject_type on (subject_type.id_subject = daily_report.id_subject) where id_member = '$member'";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysql_fetch_array($objQuery);
Code (PHP) ในส่วน department
$strSQL1 = "Select * from member inner join department on (department.id_department = member.id_department) where id_member = '$member'";
$objQuery1 = mysql_query($strSQL1) or die ("Error Query [".$strSQL1."]");
$objResult1 = mysql_fetch_array($objQuery1);