I need to display some data in ASP and I want to return it from a VFP COM object using ADO. The data I need is currently stored in two VFP DBC's which are accessed using ODBC for portability as the datasource might change to SQL server or Oracle.

Is there any way to make a select statement that will either grab the data from those two databases at the same time, or that I can use two selects which I can then combine into an ADO object using a third?

Johan IJzerman
Digital Dynamics ITC