Advertisement
Guest User

Untitled

a guest
Jul 31st, 2015
223
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.13 KB | None | 0 0
  1. SELECT a.*
  2. FROM a
  3. LEFT JOIN b ON b.a_id = a.id
  4. LEFT JOIN c ON c.a_id = a.id
  5. WHERE COUNT(DISTINCT b.id) < COUNT(DISTINCT c.id)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement