รบกวนช่วยดูโค้ด Select จาก 2 ตารางหน่อยค่ะ ข้อมูลโชว์ไม่หมด (มือใหม่ค่ะ)

<?
	
    mysql_connect("$hostname", "$username", "$password") or die(mysql_error());
    mysql_select_db("$db_name") or die(mysql_error());
	$str = "SELECT leader.username leader.firstname leader.lastname local.local FROM leader,local by id ASC where leader.id = local.id";
	$res=mysql_query($sql) or die(mysql_error());
	while($data = mysql_fetch_assoc($res)){
?>

	<TR> 
					
		<TD align="center"><?=$data["username"];?></a></TD>
				
		<TD align="center"><?=$data["firstname"];?></TD>
				
		<TD align="center"><?=$data["lastname"];?></TD>
		
		<TD align="center"><?=$data["local"];?></TD>
				
		<TD align="center"><a href="javascript:popup('viewuser.php?id=<?=$data["id"];?>','',500,550)" style="text-decoration:none"><img src="userview.png"></a></TD>
				
		<TD align='center'><a href='deleteuser.php?id=<?=$data["id"];?>' onclick="return confirm('ยืนยันการลบ')"><img src="deleteicon.png"> </TD>
				
				
	</TR> 
	<?
	  }
	?>