Advertisement
johncarlson21

routes insert ids

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