Advertisement
Guest User

Untitled

a guest
Jan 21st, 2017
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. SELECT country_id FROM countries WHERE country_id NOT IN (SELECT c.country_id
  2. FROM
  3. countries c
  4. INNER JOIN locations l on c.country_id = l.country_id
  5. INNER JOIN departments d ON d.location_Id = l.location_id GROUP BY c.country_id)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement