Correlated SubQuery

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)