Re: Retrieve data from two databases

On Jan 19, 12:44 pm, saju..._at_gmail.com wrote:
> Hello ,
>
> I need to make a query to get and compare data from two databases . I
> tried a query with inner join ..but it did not work ...gave me and
> error that the query is not properly ended .
> Can anyone help me in this ?
> I am using oracle 8i .
>
> sars

And your statement was?
There is nothing special with such a query. just
select e.*
from emp e, dept_at_remote d
where d.deptno = e.deptno
/

and that is all

-- 
Sybrand Bakker
Senior Oracle DBA