Mixing RecordSets

I'm using .asp pages to act as a front end to a MS-SQL server. I have the following problem:

I need to JOIN two tables from different databases on the server. I've got it down to two recordsets, for instance, prjRst (and) crsRst. How do I treat those recordsets as tables such that I can do an INNER JOIN on the recordsets in order to end up with one *master* recordset?

I do have a colum with similar information in each table, but the colums are named differently. Lets say that prj.prj_id contains the same information as crs.crs_id. I'd like to JOIN on that column if it's possible.

Any help would be greatly appreciated.

While the tables live in seperate databases I don't think you can do any kind of 'Join' operation ... don't tables to be 'joined' need to 'live' in the same table space ?

It might be version specific .... 'cos have a look at this Query multiple databases with one sql statement

However I'm none too sure whether this just happens to be two seperate Databases in the same table space, this guy is talking about Oracle, which can connect to multiple databases, but as far as Oracle is concerned ... all accessable databases live in its table space ... MS -SQL is different ! (Huh? Aren't all SQL implementations the same ? Nope ... not with 'external' datasources.... ! :eek2: ).