【单选题】
A SELECT E.NAME,J.JOB_NAME FROM EMPLOYEES E JOIN JOBS J ON E.JOB_ID = J.JOB_ID
B SELECT E.NAME,J.JOB_NAME FROM EMPLOYEES E LEFT JOIN JOBS J ON E.JOB_ID = J.JOB_ID
C SELECT E.NAME,J.JOB_NAME FROM EMPLOYEES E FULL JOIN JOBS J ON E.JOB_ID = J.JOB_ID
D SELECT E.NAME,J.JOB_NAME FROM EMPLOYEES E,JOBS J WHERE E.JOB_ID = J.JOB_ID(+)
查看更多