返回数说广场
0
EMPLOYEES和DEPARTMENTS表有2个等义命名字段:DEPARTMENT_ID 和 MANAGER_ID。如下哪些语句基于DEPARTMENT_ID进行等值连接?[[D]]
A
2.SELECT * FROM EMPLOYEES NATURAL JOIN DEPARTMENTS USING (DEPARTMENT_ID);
B
1.SELECT * FROM EMPLOYEES NATURAL JOIN DEPARTMENTS;
C
3.SELECT * FROM EMPLOYEES E NATURAL JOIN DEPARTMENTS D ON E.DEPARTMENT_ID=D.DEPARTMENT_ID;
D
以上都不对
NATURAL JOIN是基于两个表中所有同名的列进行等值连接的。
0
0 135
分享
评论
热门数说


