ต้องการที่จะให้ตาราง2ตาง ซึ่งมีข้อมูล 1 ฟิล ที่เก็บเหมือนกัน ไม่ทราบว่าจะทำการเชื่อมข้อมูลยังไงครับ รายละเอียดด้านในเลยครับ

include "../include/config.inc.php";
$list_page = 1;
if (empty($page)){
		$page=1;
		$n=0;
	}
if($id_attend!=""){
	$sql = "select * from tbl_attend where id_type='1'";
	}else $sql = "select * from tbl_attend where id_type='1'";	
$result = mysql_db_query($dbname,$sql) or die(mysql_error());
$NRow = mysql_num_rows($result);
$rt = $NRow%$list_page;
if($rt!=0) { 
	$totalpage = floor($NRow/$list_page)+1; 
}
else {
	$totalpage = floor($NRow/$list_page); 
}
	$goto = ($page-1)*$list_page;
$sql = "SELECT tbl_attend.*,tbl_researcher.*,tbl_institution.*,tbl_type.* FROM tbl_attend,tbl_researcher,tbl_institution,tbl_type WHERE tbl_researcher.id_researcher = tbl_attend.id_researcher AND tbl_institution.id_institution = tbl_attend.id_institution AND tbl_type.id_type = tbl_attend.id_type AND tbl_attend.id_type = '1' order by tbl_attend.id_researcher limit $goto,$list_page"; 

$sql1 = "SELECT * FROM tbl_bold WHERE id_type = '1'";

$dbquery1 = mysql_db_query($dbname, $sql1);
$dbquery = mysql_db_query($dbname, $sql);

while ($result = mysql_fetch_array($dbquery))  //ช่วงการเรียกข้อมูล ซึ่งผมแก้ไม่ตก
{
    echo $id_attend = $result[id_attend];
	$id_researcher = $result[id_researcher];
	$researcher = $result[researcher];
	$institution = $result[institution];
	$tel = $result[tel];
	$types = $result[types];
	$pic = $result[pic];
	$name_pic = "../images/person/$pic";
	$name_picn = "../images/person/noperson";
	$special = $result[special];
	$n++;
	//$n--;
If ($bg=="#D5D5D5"){$bg="#E5E5E5";}Else{$bg="#D5D5D5";}
?>
                        <tr bgcolor="<?=$bg;?>">
                          <td align=center valign="middle" nowrap><font color="#3d3d3d">
                            <?=$n;?>
                            .</font></td>
                          <td align="left" valign="middle" nowrap><font color="#3d3d3d">
                            <?=$researcher;?>
                          </font></td>
                          <td align="center" valign="middle" nowrap><font color="#3d3d3d">
                            <?=$institution;?>
                          </font></td>
                          <td align="center" valign="middle" nowrap><font color="#3d3d3d">
                            <?=$tel;?>
                          </font></td>
                          <td align="center" valign="middle" nowrap><font color="#3d3d3d">
                            <?=$special;?>
                          </font></td> 
                          <td align="center" valign="middle" nowrap><font color="#3d3d3d">
                            <?=$types;?>
                          </font></td>
                          <td align="center" valign="middle" nowrap><? if($pic!=""){?>
                            <a href="<?=$name_pic;?>"><img src="<?=$name_pic;?>" alt="" width="110" height="130" border="0"></a>
                            <? } else {?>
                            <img src="<?=$name_picn;?>" alt="" width="110" height="130" border="0">
                            <? } ?></td>
                          </tr>
                        <? }?>
                        <!--End Row -->
                      </tbody>
                    </table>
                    <?