433.sql

来自「本文件为Oracle 9i中文版基础培训教程」· SQL 代码 · 共 4 行

select  emp.empno, emp.ename, emp.deptno, dept.dname,dept.loc
from   scott.emp,scott.dept
where  scott.emp.deptno!=scott.dept.deptno and scott.emp.deptno=10;