c.sql

ORACLE数据库的交集查询

select w.employee_name,e.employee_street,e.employee_city from works w,employee e
where company_name='Downtown' and w.employee_name=e.employee_name and w.salary>=800;