请说明原因,1.SELECTA.FIRST_NAME FROM EMPLOYEES A LEFT JOIN EMPLOYEES B ON A.EMPLOYEE_ID=B.MANAGER_ID WHERE B.FIRST_NAME ='David' 2.SELECT A.FIRST_NAME FROM EMPLOYEES A ,EMPLOYEES B WHERE A.EMPLOYEE_ID=B.MANAGER_ID AND B.FIRST_NAME ='David'
来源:学生作业帮助网 编辑:作业帮 时间:2024/11/17 02:49:05
请说明原因,1.SELECTA.FIRST_NAME FROM EMPLOYEES A LEFT JOIN EMPLOYEES B ON A.EMPLOYEE_ID=B.MANAGER_ID WHERE B.FIRST_NAME ='David' 2.SELECT A.FIRST_NAME FROM EMPLOYEES A ,EMPLOYEES B WHERE A.EMPLOYEE_ID=B.MANAGER_ID AND B.FIRST_NAME ='David'
请说明原因,
1.SELECTA.FIRST_NAME FROM EMPLOYEES A LEFT JOIN EMPLOYEES B ON A.EMPLOYEE_ID=B.MANAGER_ID WHERE B.FIRST_NAME ='David'
2.SELECT A.FIRST_NAME FROM EMPLOYEES A ,EMPLOYEES B WHERE A.EMPLOYEE_ID=B.MANAGER_ID AND B.FIRST_NAME ='David'
请说明原因,1.SELECTA.FIRST_NAME FROM EMPLOYEES A LEFT JOIN EMPLOYEES B ON A.EMPLOYEE_ID=B.MANAGER_ID WHERE B.FIRST_NAME ='David' 2.SELECT A.FIRST_NAME FROM EMPLOYEES A ,EMPLOYEES B WHERE A.EMPLOYEE_ID=B.MANAGER_ID AND B.FIRST_NAME ='David'
下面的,下面的属于内联,外联要比内联多一步添加主表的非关联性数据