Please help use INNER join multiple tables in sqlsrv with php

Quote:

<?php
$serverName = "SQLSERVER";
$userName = "sa";
$userPassword = "123456";
$dbName = "Product";
$connectionInfo = array("Database"=>$dbName,"characterSet"=>"UTF-8", "UID"=>$userName, "PWD"=>$userPassword, "MultipleActiveResultSets"=>true);
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
$sql = "SELECT * FROM NhanVien
INNER JOIN DM_PhongBan ON TenNhanVien.PhongBan_id = DM_PhongBan.PhongBan_id";
$stmt = sqlsrv_query($conn, $sql);
$params = array();
/* Retrieve each row as an associative array and display the results.*/
while( $row = sqlsrv_fetch_object( $stmt, SQLSRV_FETCH_ASSOC))
{
echo $row['MaNhanVien'].", ".$row['TenNhanVien']."\n";
}

/* Free statement and connection resources. */
//sqlsrv_free_stmt( $stmt);
sqlsrv_close( $conn);
?>