วีธีอ้างคีย์นอกของอีกตารางนึง ให้โชว์ชื่อ กับ นามสกุล ทำยังไงคะ มี 2 ตารางคะ คือ ตาราง employee กับ ตาราง employeele

<?php
	$objConnect = mysql_connect("localhost","root","1234");
	$objDB = mysql_select_db("con_leaveonline");
	mysql_query("SET NAMES UTF8"); 
?>

<?php
$strSQL =	"
				SELECT employee.*,employee.* FROM employee,employeele
				WHERE employee.em_id = employeele.em_id
				";
	$objQuery = mysql_query($strSQL);
	$objResult = mysql_fetch_array($objQuery);
	echo $objResult["em_name"];
			
?>

<?php
	$objConnect = mysql_connect("localhost","root","1234");
	$objDB = mysql_select_db("con_leaveonline");
	mysql_query("SET NAMES UTF8"); 

$strSQL =	"
SELECT employee.*,employeele.* FROM employee 
LEFT JOIN employeele 
ON employee.em_id = employeele.em_id 
";
	$objQuery = mysql_query($strSQL);
	$objResult = mysql_fetch_array($objQuery);
	echo $objResult["em_name"];
			
?>

<?php
	$objConnect = mysql_connect("localhost","root","1234");
	$objDB = mysql_select_db("leaveonline");
	mysql_query("SET NAMES UTF8");
 
$strSQL =   "
SELECT employee.*,employeele.* FROM employee
LEFT JOIN employeele
ON employee.em_id = employeele.em_id
";
	$objQuery = mysql_query($strSQL);
	$objResult = mysql_fetch_array($objQuery);
	echo $objResult["em_name"];
?>
<?php
	mysql_close($objConnect);
?>