Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT e.first_name||' '||e.last_name, d.department_name, c.country_name
- FROM countries c, departments d, locations l, employees e
- WHERE c.country_name LIKE ('United States of America')
- INTERSECT
- SELECT e.first_name||' '||e.last_name, d.department_name, c.country_name
- FROM countries c, departments d, locations l, employees e
- WHERE d.department_name IN ('IT', 'Accounting')
- AND e.department_id=d.department_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement