Oracle 中 using的用法问题1.SELECT e.last_name,d.department_name,d.location_idFROM employees e JOIN departments dUSING (department_id );里面using (department_id 2Q:In which three cases would you use the USING clause?(Choose three.)A.You want
来源:学生作业帮助网 编辑:作业帮 时间:2024/11/26 08:30:53
Oracle 中 using的用法问题1.SELECT e.last_name,d.department_name,d.location_idFROM employees e JOIN departments dUSING (department_id );里面using (department_id 2Q:In which three cases would you use the USING clause?(Choose three.)A.You want
Oracle 中 using的用法问题
1.
SELECT e.last_name,d.department_name,d.location_id
FROM employees e JOIN departments d
USING (department_id );
里面using (department_id
2Q:In which three cases would you use the USING clause?(Choose three.)
A.You want to create a nonequijoin.
B.The tables to be joined have multiple NULL columns.
C.The tables to be joined have columns of the same name and different data types.
D.The tables to be joined have columns with the same name and compatible data types.
E.You want to use a NATURAL join,but you want to restrict the number of columns in the join condition.
能举例说明下吗?
Oracle 中 using的用法问题1.SELECT e.last_name,d.department_name,d.location_idFROM employees e JOIN departments dUSING (department_id );里面using (department_id 2Q:In which three cases would you use the USING clause?(Choose three.)A.You want
1.相当于 on e.department_id = d.department_id
即通过该字段将两个表关连
2.BDE