Advertisement
johncarlson21

Untitled

Oct 10th, 2013
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.22 KB | None | 0 0
  1. SELECT route_id
  2. FROM insert_route
  3. WHERE (
  4. INSERT_ID IN ( 12 )
  5. AND INSERT_ID NOT
  6. IN ( 21 )
  7. )
  8. AND route_id
  9. IN ( 48, 49, 44, 50, 55, 43, 51, 25, 24, 52, 47, 31, 53 )
  10. GROUP BY route_id
  11. HAVING count( DISTINCT
  12. INSERT_ID ) =1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement