i have the following:

Stored Procedure 1 calls Query 1

Stored Procedure 2 calls Query 2

i would like to have:

Stored Procedure 3 calling Query 1 and Query 2 and then combine results.

Query 1 is to select data from table1

Query 2 is to select data from table2

Both table1 and table2 have same structure..

My actual need is

combine data from Query 1 and data from Query2 ,and return single data