Oracle多表连接与子查询(转)
摘要:
1:等值连接 迪卡尔集连接 select ename, a.deptno as a_deptno,b.deptno as b_deptno ,b.dname as 部门 from emp a, dept b 等值连接 select ename, a.deptno as a_deptno,b.deptno as b_deptno ,b.dname as 部门 from emp a, dept b ... 阅读全文
posted @ 2010-09-02 17:39 Ben zhang 阅读(255) 评论(0) 推荐(0) 编辑