1 select e.ename, d.loc from emp e join dept d on (e.deptno=d.deptno); |
2 select e.ename, d.loc from emp e inner join dept d using (deptno); |
3 select e.ename, d.loc from emp e natural join dept d; |
4 select e.ename, d.loc from emp e natural join dept d using (deptno); |
5 select e.ename, d.loc from emp e natural inner join dept d; |
|
Q5. 다음 중 에러가 발생하는 SQL 조인문장을 찾으시오 (2개) p320-321
1 select e.ename, e.deptno, d.loc, s.grade from emp e join dept d join salgrade s on e.deptno=d.deptno and e.sal between s.losal and s.hisal; |
2 select e.ename, e.deptno, d.loc, s.grade from emp e inner join dept d on e.deptno=d.deptno join salgrade s on e.sal between s.losal and s.hisal; |
3 select e.ename, deptno, d.loc, s.grade from emp e join dept d using (deptno) join salgrade s on e.sal between s.losal and s.hisal; |
4 select e.ename, e.deptno, d.loc, s.grade from emp e, dept d, salgrade s where e.deptno=d.deptno and e.sal between s.losal and s.hisal; |
5 select e.ename, e.deptno, d.loc, s.grade from emp e join dept d on e.deptno=d.deptno join salgrade s and e.sal between s.losal and s.hisal; |
|