446.sql

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

select  emp.empno,emp.ename,emp.job,emp.sal  
from scott.emp,scott.dept
where exists
(select * from scott.emp where scott.emp.deptno=scott.dept.deptno);