Re: Help required for a Query

I can't give advise about the specific query that you could use, as the problem is not clearly described. Post DDL rather then an explanation of the data structure.

To query a database from another database, use a database link. Tables in the remote database are accessed using @table_name.

Hth,
Radu
"tommiy" <tommiy_at_ozemail.com.au> wrote in message news:fe2fa8d3.0111030400.5e61071f_at_posting.google.com...
> I have a what is probably a simple question for someone with more sql
> knowledge than myself and am hoping someone has the time to offer some
> suggestions.
>
>
> I have two separate databases. The first contains data regarding some
> high level detail, the second the low level detail. There is a
> reference in a table in the first database that acts as a key to a
> table in the second database.
>
> My problem is that I need to recover all records pertainingr to a
> specific element from the first database and then obtain all the low
> level detail from the second. How do I do this?
>
> If they were both part of the same database I could just use a sub
> select and and IN clause (I think)...but how do I do this when the sub
> select would have to be in a different database?
>
> Any help appreciated I'm getting tired at looking at way of doing this
> and I'm sure that it shouldn't be that hard...is it?
Received on Sat Nov 03 2001 - 10:08:16 CST