Sub query usually more efficient because
Data is filtered in the database
Data is filtered on the network
Data is filtered in the sapgui
Data is filtered at the application server