Correlated SubQuery

Saranya Boopathi
Posted by Saranya Boopathi under Sql Server category on | Points: 40 | Views : 866
Correlated SubQuery :Inner query is depend upon the outer query.

select * from Book_Imp_Det a where book_id in
(Select b_id from Book_details b where b.b_id=a.book_id)

Comments or Responses

Login to post response