d.sql

ORACLE数据库的交集查询

select w.employee_name from works w,employee e,company c
where w.employee_name=e.employee_name and c.company_name=w.company_name and e.employee_city=c.company_city;