数据库查询

select A.jobid ,A.Shendate,A.UserId,B.JobName,C.UserName,C.iname from Job_perapplyrec as A,job_zhaoping as B,job_person as C
where A.JobId=B.[id] and A.UserID=C.[ID]