I need to create a resultset based on a join between two tables in different
MSSQL 6.5 databases.  I know this can be done with 7.0, but that is not an
option for us at this time.  Any help would be greatly appreciated.

I am using VBEE 5.0 and RDO 2.0

Thanks for you help,

Matt Childs
Sr. Systems Analyst/Developer
Integrity Solutions Inc.

You do not indicate whether the databases are on the same server, or on
different servers.

If they are on the same server, then you should be able to join just by using
the fully-qualified table name ...

<database>.<owner>.<table>

for example pubs.dbo.authors

If they are on different servers, then you can not do a direct join. You can
however execute a remote stored procedure to bring data from the remote server,
load it into a temp table, and then do a local join to it.

---------------------------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc) which can be
cut and pasted into Query Analyzer is appreciated.