b.sql

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

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