Re: Retrieve data from two databases

This was the error :

ERROR at line 1:
ORA-00933: SQL command not properly ended

I need oracle syntax...could you help me out ? gazzag wrote:
> sajuars_at_gmail.com wrote:
> > 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;
>
> ... and the error that you received was?
>
> Also, that looks like SQL Server syntax to me.
Received on Fri Jan 19 2007 - 07:51:57 CST