combine 2 result sets to get one

[Anon]

i am connecting to 2 databases on 2 different servers, the table structure is the same on both. I can get the 2 result sets from each one, now what I would like to do is combine these 2 record sets (arrays) into one big record set or array.

How would I go about putting the two together w/out writing over any data in either, just simply putting one to the end of another?

[[deleted]]

one big recordset is impossible, but you can ofcourse read both recordsets into the same array. If you can read both sets into seperate arrays you can also read both sets into the same array.