Advertisement
Guest User

Untitled

a guest
Apr 20th, 2015
215
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. select id,name from providers where id not in (
  2. select c.provider_id from token_maps a
  3. inner join token_map_groups b ON b.token_map_id = a.id
  4. inner join token_map_group_providers c on c.token_map_group_id=b.id
  5. left join providers p on p.id=c.provider_id
  6. where a.id=2
  7. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement