When you say combined, do you mean that they have the same structure and need to be seen as a single results set in which case you can use

UNION

or

UNION ALL (if there are potential duplicates between the results sets which you want to eliminate)

Or do you mean that you need to JOIN the tables on a common field in which case you will need to capture the results sets into temp tables and work with them there.