สอบถามเรื่องการดึงค่า จากตาราง 3 ตาราง รบกวนด้วยนะค่ะ

$SQL="select event_start, event_end, event_title, user_book, group_concat(name_room) from  tbl_event ev, ref_book rf, db_room rm,ref_tool rt,db_tool dt where ev.event_title=rf.event_title and rf.room_book = rm.id_room and rt.no_tool = dt.no_tool GROUP BY event_start, event_end, event_title, user_book";

$SQL="select * from  tbl_event ev , ref_book rf, db_room rm  where ev.event_title=rf.event_title and rf.room_book = rm.id_room"; ไม่error แต่มันไม่กรุ๊ปแบบที่พี่แนะนำ

$SQL="select event_start, event_end, event_title, user_book, group_concat(name_room) from  tbl_event ev , ref_book rf, db_room rm  where ev.event_title=rf.event_title and rf.room_book = rm.id_room GROUP BY event_start, event_end, event_title, user_book"; ลองใส่เอง error

$SQL="select ev.event_start, ev.event_end, ev.event_title, ev.user_book, rf.id_room, rm.name_room , GROUP_CONCAT(name_room SEPARATOR ',')
from tbl_event ev , ref_book rf, db_room rm
where ev.event_title=rf.event_title
and rf.id_room=rm.id_room
group by ev.event_start, ev.event_end, ev.event_title, ev.user_book";

select 
	ev.event_id,
	ev.event_status,
	ev.event_start, 
	ev.event_end, 
	ev.event_title, 
	ev.user_book, 
	rf.id_room, 
 
	GROUP_CONCAT(rm.name_room SEPARATOR ',<br>') gc
from tbl_event ev , ref_book rf, db_room rm
where ev.event_title=rf.event_title
and rf.id_room=rm.id_room 
group by ev.event_start, ev.event_end, ev.event_title, ev.user_book
ORDER BY event_title ASC

<?

$strSQL = "select 
	ev.event_id,
	ev.event_status,
	ev.event_start, 
	ev.event_end, 
	ev.event_title, 
	ev.user_book, 
	rf.id_room, 
	GROUP_CONCAT(rm.name_room SEPARATOR ',<br>') gc
from tbl_event ev , ref_book rf, db_room rm
where ev.event_id=rf.event_id and rf.id_room=rm.id_room  and date(ev.event_start)=curdate()
group by ev.event_start, ev.event_end, ev.event_title, ev.user_book ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);


?>
          <table class="data1">
            <tr class="data1">
              <th class="data1" width="6%">สถานะ</th>
              <th class="data1" width="11%">วันเวลาที่เริ่ม</th>
              <th class="data1" width="11%">วันเวลาสิ้นสุด</th>
              <th class="data1" width="19%">หัวข้อการขอจองห้องประชุม</th>
              <th class="data1" width="16%">ห้องประชุม<br />
                ที่จอง</th>
              <th class="data1" width="14%">อุปกรณ์ที่จอง</th>
              <th class="data1" width="13%">ผู้จอง</th>
              </tr>
            <?
while($objResult = mysql_fetch_array($objQuery))
{

?>
            <tr class="data1">
              <td class="data1" width="6%"><center>
                <a href="user_change_status_meeting.php?status=<?=$objResult["event_status"];?>&amp;&amp;event_id=<?=$objResult["event_id"];?>">
                  <?	if($objResult["event_status"]=='1')
			{
				echo "<img src='../img/accept.png' height='25' width='25'>";
			}
			else if($objResult["event_status"]=='2')
			{
				echo "<img src='../img/clock.png' height='25' width='25'>";
			}
			else if($objResult["event_status"]=='3')
			{
				echo "<img src='../img/block.png' height='25' width='25'>";
			}
            ?>
                  </a>
              </center></td>
              <td class="data1" width="11%"><? echo $objResult['event_start']; ?></td>
              <td class="data1" width="11%"><? echo $objResult['event_end']; ?></td>
              <td class="data1" width="19%"><? echo $objResult['event_title']; ?></td>
              <td class="data1" width="16%"><? echo $objResult['gc']; ?></td>
              <?
              
			  $SQL1="select 
	ev.event_start, 
	ev.event_end, 
	ev.event_title, 
	ev.user_book, 
	rt.no_tool, 
	tl.name_tool , 
	GROUP_CONCAT(tl.name_tool SEPARATOR ',<br>') gd
from tbl_event ev , ref_tool rt, db_tool tl
where ev.event_id=rt.event_id 
and rt.no_tool=tl.no_tool 
group by ev.event_start, ev.event_end, ev.event_title, ev.user_book
ORDER BY ev.event_start ASC 

";

 $QUERY= mysql_query($SQL1) or die( mysql_error() . "customer Error Query[ $sql1 ]");
 $rs=mysql_fetch_array($QUERY);
			  ?>
              <td class="data1" width="14%"><? echo $rs['gd']; ?></td>
              <td class="data1" width="13%"><? echo $objResult['user_book']; ?></td>
              </tr>
            <? 
		}
        ?>
          </table></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td bgcolor="#FFFFFF">&nbsp;</td>
      </tr>
      <tr>
        <td bgcolor="#FFFFFF">&nbsp;</td>
      </tr>
      <tr>
        <td bgcolor="#FFFFFF">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td valign="top" bgcolor="#FFFFFF" >&nbsp;</td>
  </tr>
  <tr>
    <td colspan="2" valign="top" bgcolor="#000000"><br />
    <br /></td>
  </tr>
</table>

<?

$strSQL = "select 
	ev.event_start, 
	ev.event_end, 
	ev.event_title, 
	ev.user_book, 
	rf.id_room, 
	GROUP_CONCAT(name_room SEPARATOR '<br>') gc,
	GROUP_CONCAT(name_tool SEPARATOR '<br>') gt
from tbl_event ev
left join ref_book rf on ev.event_id=rf.event_id 
left join db_room rm on rf.id_room=rm.id_room
left join ref_tool rt ON ev.event_id=rt.event_id
left join db_tool tl ON rt.no_tool=tl.no_tool 
group by event_start, event_end, event_title, user_book";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);


?>
          <table class="data1">
            <tr class="data1">
              <th class="data1" width="6%">สถานะ</th>
              <th class="data1" width="11%">วันเวลาที่เริ่ม</th>
              <th class="data1" width="11%">วันเวลาสิ้นสุด</th>
              <th class="data1" width="19%">หัวข้อการขอจองห้องประชุม</th>
              <th class="data1" width="16%">ห้องประชุม<br />
                ที่จอง</th>
              <th class="data1" width="14%">อุปกรณ์ที่จอง</th>
              <th class="data1" width="13%">ผู้จอง</th>
              </tr>
            <?
while($objResult = mysql_fetch_array($objQuery))
{

?>
            <tr class="data1">
              <td class="data1" width="6%"><center>
                <a href="user_change_status_meeting.php?status=<?=$objResult["event_status"];?>&amp;&amp;event_id=<?=$objResult["event_id"];?>">
                  <?	if($objResult["event_status"]=='1')
			{
				echo "<img src='../img/accept.png' height='25' width='25'>";
			}
			else if($objResult["event_status"]=='2')
			{
				echo "<img src='../img/clock.png' height='25' width='25'>";
			}
			else if($objResult["event_status"]=='3')
			{
				echo "<img src='../img/block.png' height='25' width='25'>";
			}
            ?>
                  </a>
              </center></td>
              <td class="data1" width="11%"><? echo $objResult['event_start']; ?></td>
              <td class="data1" width="11%"><? echo $objResult['event_end']; ?></td>
              <td class="data1" width="19%"><? echo $objResult['event_title']; ?></td>
              <td class="data1" width="16%"><? echo $objResult['gc']; ?></td>
              
	
              <td class="data1" width="14%"><? echo $objResult['gt']; ?></td>
              <td class="data1" width="13%"><? echo $objResult['user_book']; ?></td>
              </tr>
            <? 
		}
        ?>
          </table>

<?

$strSQL = "select event_start, event_end, event_title, user_book, id_room,
	GROUP_CONCAT(name_room SEPARATOR '<br>') gc,
	GROUP_CONCAT(name_tool SEPARATOR '<br>') gt
from (
select distinct 
	ev.event_start, 
	ev.event_end, 
	ev.event_title, 
	ev.user_book, 
	rf.id_room, 
	rm.name_room , 
	tl.name_tool
from tbl_event ev , ref_book rf, db_room rm, ref_tool rt, db_tool tl
where ev.event_id=rf.event_id
and rf.id_room=rm.id_room
and ev.event_id=rt.event_id
and rt.no_tool=tl.no_tool
) tmp
group by event_start, event_end, event_title, user_book";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);


?>