Combining Recordsets

[Guest_imported]

Hi,

I'm trying to find a way to combine two separate recordsets into one recordset so it can be resorted. Does anyone know of a way to do ths? What I need s two separate unrelated sql queries to be merged and sorted as one set of data.

Thanks,
David Capone

 

[forecasting]

I think you want to perform a UNION query. The SQL Server area is a better forum to get help.