Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
39
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. select doc_id from request
  2. where id in
  3. (select r.root_id from request r, action a where a.request_id = r.id and a.ID
  4. in (1253960076) );
  5.  
  6. SELECT r.doc_id,a.id
  7. FROM request r
  8. INNER JOIN action a
  9. ON r.id=a.request_id
  10. WHERE a.id in (1253960076)
  11.  
  12. SELECT
  13. r.doc_id,
  14. a.ID
  15. FROM
  16. request r
  17. INNER JOIN action a ON a.request_id = r.id
  18. WHERE
  19. a.ID IN (1253960076)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement