If you use an sql select statement then that is send to the database as is. Qlikview doesn't process it, the dbms it is send to does. So you can do whatever you want in sql as long as your dbms supports it.
The load statement can't do 'subselects'. The usual way is to use the exists function in a where clause or use the keep function. Here's a discussion with an example of both.