Merging data from two datasets

[Josh]

I'm trying to merge two datasets together, but not in the normal
fashion. I have 2 instances of SQL db's. Due to constraints, I can't
create a db link between the two. So, I'm forced to do 1 request to
each. The problem is I would like my final result set to be merged
together using foreign keys.

Example: I select id1, something1, somethingelse1, id2 from tbl1 and
id2, idea1, newidea1 from tbl2. In my results, I would like to
combine the two using id2, which is the foreign key in tbl1 to the
primary key in tb2. I would normally do a sub-select in one query but
don't have the capability right now.

Is there any way of doing this without having to go through a manual
process of physically creating a 3rd container to have a merge of both
sets? I'm obviously trying to limit the queries within queries
situation.

Thanks!

 

[Cor Ligthert]

Josh,

When you can do it, and can't find a method that fits, than do it the way
you can do it.

Don't forget that a method in a class is behind the scene often written in
the same way as you do it. In addition there are no standard methods for non
standard problems.

Just my thought,

Cor