รบกวนด้วยค่ะ คืออยากให้ช่วยแนะนำ code การ join ตาราง และการ count ในตารางที่ join กันค่ะ

 $com = mysql_query("select  activity.*,member.*,act_count_stam.*
from activity,member,act_count_stam 
where activity.m_id=member.m_id 
and act_count_stam.act_count_id=activity.act_count_id order by act_id desc") or die ("Err Can not to result");		

$sum_com = mysql_num_rows($com);
?>
<?php
//การ count ในตาราง act_count_stam
$query = "SELECT act_id, SUM(count_act) FROM act_count_stam GROUP BY act_id"; 
	 
$result1 = mysql_query($query) or die(mysql_error());


?>
<table width="100%" height="55" border="1" cellpadding="0" cellspacing="0" bordercolor="#FF6600">
  <tr bgcolor="#FFDC62" class="style21">
          <td width="44" height="19"  bgcolor="#FFCC66"><div align="center" class="style56">รหัส</div></td>
          <td width="58" height="19"  bgcolor="#FFCC66"><div align="center" class="style56">ผู้โพตส์</div></td>
          <td width="112"  bgcolor="#FFCC66"><div align="center" class="style56">ชื่อกิจกรรม</div></td>
          <td width="109"  bgcolor="#FFCC66"><div align="center" class="style56">รายละเอียด</div></td>
                <td width="96"  bgcolor="#FFCC66"><div align="center" class="style56">จำนวนแจ้งลบ</div></td>
          <td width="49"  bgcolor="#FFCC66"><div align="center" class="style56">ลบ</div></td>
          <? 
		  
		   

		
while($dbarrcom=mysql_fetch_array($com)){ // แสดงคอมเม้น 
$act_name = $dbarrcom[act_name];
$comment=$dbarrcom['act_detail'];
$act_id1 = $dbarrcom['act_id'];


// Print out result
while($row = mysql_fetch_array($result1)){
	$count_act = $row['type']. $row['SUM(count_act)'];
	$act_id = $row[act_id];
	


			 ?>
<?


	echo "
			<TR> 
			<TD align ='center' class='style56'>$act_id</TD>	
			<TD align ='center' class='style56'><img src='../images/pro_small/".$dbarrcom['m_img']."' width='50' height='50' /></a></TD>	
			<TD align ='center' class='style56'>$act_name</TD>
			<TD align ='center' class='style56'>$comment  </TD>
			<TD align ='center' class='style56'> $count_act</TD>
			<TD align ='center' class='style56'><A HREF=\"delete_stam_act.php?delete=$act_id&act_id1=".$dbarrcom[act_id]."&act_id=".$row['act_id']."\" onclick=\"return confirm('ยืนยันการลบกิจกรรม [$act_name] ')\">[ลบ]</A></TD>
			</TR>";

	 }
			
			}

	?>
        </tr>
        
      </table>