if we want to retrive data from more than one table byusing join conditions then we go to join based on the type type of join condition.sub query is nested quires there is no need of any join condition