Oracle中的一连接语句
时间:2022-03-14 04:45
首先构建场景
相应表中数据如下:
1 SELECT * FROM EMPLOYEE;
1 SELECT * FROM DEPTINFO;
1 SELECT E.EMPNAME, D.DEPNAME 2 FROM EMPLOYEE E, DEPTINFO D 3 WHERE E.DEPTID = D.DEPID 4 ORDER BY DEPNAME;
1 SELECT E.EMPNAME, D.DEPNAME 2 FROM EMPLOYEE E 3 JOIN DEPTINFO D 4 ON E.DEPTID = D.DEPID 5 ORDER BY DEPNAME;JOIN