run two queries one return

[eluser]tim1965[/eluser]
Hi

Apologies if this is a stupid question.

I want to run a numer of different queries in one function in my model. However i only want to return one dataset, combining all the results.
Similar to chaining a set of queries using transaction, but only returning one array of data containing all the resultsets.
I need to run a number of select min and maxs and then combine them with a further more complex select. I cannot get these to play together nicely.
I know i can probably do this in my controller, but thought i would check if there is a shortcut.
So is this possible, and if so how. Thanks in advance