Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Retrieve data from two databases

Re: Retrieve data from two databases

From: gazzag <gareth_at_jamms.org>
Date: 19 Jan 2007 04:09:14 -0800
Message-ID: <1169208554.533199.92430@38g2000cwa.googlegroups.com>


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 - 06:09:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US