Re: Retrieve data from two databases

Here's the query i used ..

select x.dbo.table.field,y.dbo.table.field from x.dbo.table inner join y.dbo.table where x.dbo.table.field2=43 and y.dbo.table.field2=43;

gazzag wrote:
> sajuars_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
>
> Post the query that you've tried with the *exact* error message that
> you received. Copy & Paste it so the group can see it for themselves.
>
> Until you do that, we can't help you.
>
> Hope This Helps
>
> -g
Received on Fri Jan 19 2007 - 05:57:20 CST