Advertisement
DimitarVasilev

Untitled

May 19th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.42 KB | None | 0 0
  1. SELECT e.first_name||' '||e.last_name, d.department_name, c.country_name
  2. FROM countries c, departments d,  locations l, employees e  
  3. WHERE c.country_name LIKE ('United States of America')
  4. INTERSECT
  5. SELECT e.first_name||' '||e.last_name, d.department_name, c.country_name
  6. FROM countries c, departments d,  locations l, employees e
  7. WHERE d.department_name IN ('IT', 'Accounting')
  8. AND e.department_id=d.department_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement