Joining two recordsets

[rajeshrakyan]

Hi

I have very complex query to execute. So what i am trying to do is to two break down the complex query in two queries . now i would like to join the results of the two query in one recordset. is it possible ?

[sead]

If memory serves, you should be able to do that with UNION query which allows you to combine fields from two (or more) queries (or tables) into the one field. Search MSDN or this forum for details...

Hope this helps,
Have a nice day

Sead