Two database query

[MartinThorpe]

Hello.

I have adopted 2 systems both with their own databases with similar data.? I
have been asked to make a query that requires comparing data from one database
with data from the other. ?I will eventually consolidate the two databases.?
But for now I need to run a Q over the two databases, they both sit under the
same datasource, this is Oracle 9i.?

I have done it like this but can?t help feeling there should be a better way,
any advice?#

Select profile.profileId
From profile, otherDatabase.company
Where
Profile.profileid = otherDatabase.company.profileid

Thanks for reading
Cheers

Martin

[MikerRoo]

The current scheme is probably not what you want.

IF the product ID's are somehow coordinated between the databases, then you
could use a full outer join to see entries that were different -- or in one DB
but not the other.

More typically, you would have to do the full outer join on the NATURAL keys
for each table (Company stock symbol or HQ address, maybe) since the same
company might have different profileids in each DB.

The smartest thing to do is to invest in a good comparison tool, like
[url]http://www.toadsoft.com/feats.html[/url], for example.