怎么用一条sql语言写下面的

Question

function get_employees_salary ($employees_id,$filed)
{
//得到员工的JobID
$employees_sql="select jobid,job_status from employees where id = '".$employees_id."' ";
$employees_result= mysql_query ($employees_sql);
$employees_row = mysql_fetch_array ($employees_result);

//得到JobID对应的工资 

$salary_sql="select $filed from employees_job where id = '".$employees_row['jobid']."'";
// and status = '".$employees_row['job_status']."'
$salary_result=mysql_query ($salary_sql);
$salary_row = mysql_fetch_array ($salary_result);

echo $salary_row[$filed];

}

Answer 1

$sql = "select a.jobid,a.job_status,b.filed from employees a, employees_job where a.id ={$employees_id} and b.id = a.jobid";

Answer 2

$sql = "select a.jobid,a.job_status,b.filed from employees as a, employees_job as b where a.id ={$employees_id} and b.id = a.jobid";

Answer 3

$sql = "select a.jobid,a.job_status,b.filed from employees a left join employees_job on b.id = a.jobid where a.id ={$employees_id}";

Answer 4

不好意思，掉了个别名
$sql = "select a.jobid,a.job_status,b.filed from employees a left join employees_job b on b.id = a.jobid where a.id ={$employees_id}";