Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select doc_id from request
- where id in
- (select r.root_id from request r, action a where a.request_id = r.id and a.ID
- in (1253960076) );
- SELECT r.doc_id,a.id
- FROM request r
- INNER JOIN action a
- ON r.id=a.request_id
- WHERE a.id in (1253960076)
- SELECT
- r.doc_id,
- a.ID
- FROM
- request r
- INNER JOIN action a ON a.request_id = r.id
- WHERE
- a.ID IN (1253960076)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement