多表查询-big.data.analytics.with.spark

第六章多表查询6.1、笛卡尔集(Cross Join) Select * from emp,dept; 6.2、等值连接(Equijoin)(Natural join..on) select empno, ename, sal, emp.deptno, dname from emp, dept where emp.deptno = dept.deptno; 6.3、非等值连接(Non-Equijoin) select ename,empno,grade from emp,salgrade where sal between losal and hisal;