ถามเรื่องการ Join ตารางครับ ผลลัพธ์ไม่ตรงกับฐานข้อมูล

$sql="select * from building,province,amphur,district where building.b_id=province.PROVINCE_ID and province.PROVINCE_ID=amphur.AMPHUR_ID and amphur.AMPHUR_ID=district.DISTRICT_ID and district.DISTRICT_ID";

<?
include("host.inc.php");

$sql="select * from building  where b_id='$b_id' ";
$dbquery=mysql_db_query($dbname,$sql);
	$result=mysql_fetch_array($dbquery);	                            
	$b_id = $result[b_id];
	$b_type = $result[b_type];
	$b_size = $result[b_size];
	$b_unit = $result[b_unit];
	$b_price = $result[b_price];
	$b_pic = $result[b_pic];
	$b_add = $result[b_add];
	$b_road = $result[b_road];
	$b_town = $result[b_town];
	$b_city = $result[b_city];
	$b_prov = $result[b_prov];
	$mem_id = $result[mem_id];
	$PROVINCE_NAME = $result[PROVINCE_NAME];
?>
<? 

		include("host.inc.php");
$sql="select * from building,province,amphur,district where building.b_id=province.PROVINCE_ID and province.PROVINCE_ID=amphur.AMPHUR_ID and amphur.AMPHUR_ID=district.DISTRICT_ID and district.DISTRICT_ID";

 		$result = mysql_query($sql);  
	
 		
?>
        <table width="400" border="3" cellpadding="2" cellspacing="2" bordercolor="#0099FF">
           		   
<TR height='20'>
	<TD width='30%' bgcolor='#CCEAFF'>ประเภท: </TD>
	<TD><?=$b_type; ?></TD>
</TR>
<TR height='20'>
	<TD bgcolor='#CCEAFF'>ขนาด : </TD>
	<TD><?=$b_size; ?> </TD>
</TR>
<TR height='20'>
	<TD bgcolor='#CCEAFF'>ราคาขาย<?=$b_unit;?>ละ : </TD>
	<TD><?=number_format($b_price); ?> บาท</TD>
</TR>
<TR height='20'>
	<TD bgcolor='#CCEAFF'>สถานที่ : </TD>
	<TD><?=$b_add; ?></TD>
</TR>
          </tr>
          <? 
$i = 0; 
while($data=mysql_fetch_array($result))
//while($objResult = mysql_fetch_array($objQuery)) 
{ 
$i++; 
?>
			<TR height='20'>
           <TD bgcolor='#CCEAFF'>จังหวัด : </TD>
		   <td><?=$data["PROVINCE_NAME"];?></td>
		   </TR>
		   <TR height='20'>
           <TD bgcolor='#CCEAFF'>อำเภอ : </TD>
		   <td><?=$data["AMPHUR_NAME"];?></td>
		   </TR>
		   <TR height='20'>
		   <TD bgcolor='#CCEAFF'>ตำบล : </TD>
		   <td><?=$data["DISTRICT_NAME"];?></td>
		   </TR>
          <tr>
             
		   
			
          
          <? 
} 
?>
        </table>