e.sql

来自「ORACLE数据库的交集查询」· SQL 代码 · 共 2 行

select e.employee_name from employee e,manages m
where m.employee_name=e.employee_name and (e.employee_street,e.employee_city)in (select e.employee_street,e.employee_city from employee e,manages m where e.employee_name=m.employee_name);