Result sets merging

Hi,

I'd like to do a kind of merging of 2 workflows:

1) I have a SQL query that give me a few properties

2) I have a SQL query followed by a rows and columns transposition that give me other property

I'd like to fill the rows of my first query with the rows of the second query.

But I don't know how to "merge" this 2 result sets in one

Hope I am clear.

Thanks for your help!