When creating a sub query the data that is returned needs to be related to the initial or Master query. The sub query cannot run independent of the master query. So the implications is that for each type of sub query different join rules exist to link the sub queries results sets with those of the master query.