e.sql

ORACLE数据库的交集查询

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);