Re: query to join two tables in 2 different Oracle schema

harryooopotter_at_hotmail.co_ (Harry) wrote in message news:<1ng9d.38959$N%.26178_at_edtnps84>...
> schema B: a table "report" with study_id, etc.
>
> select s.study_id, r.report_type
> from study s connected to schema A using userid xxx password yyy,
> report r connected to schema B using userid ppp password qqq
> where s.study_id = r.study_id
>

as study_id is within table report try
SQL> select study_id, report_type from report;

gerhard

... but that's not a post for comp.lang.perl.misc, so please check groups before posting ... Received on Fri Oct 08 2004 - 01:26:00 CDT