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: joining table from oracle db to a table in ms sql db

Re: joining table from oracle db to a table in ms sql db

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Tue, 13 Feb 2007 17:17:42 GMT
Message-ID: <WomAh.56517$Fd.29092@edtnps90>


"hrushi" <hbhome_at_gmail.com> wrote in message news:1171386377.803275.145700_at_v45g2000cwv.googlegroups.com...
>I am using following query to get data from a table in oracle db:
>
> SELECT *
> FROM OPENQUERY(ARADMIN, 'select Column1 from Oracle_Table WHERE
> status not in (''a'','b'',''c'') '
> Order by OPENEDDATE DESC
>
> I want to join a table from MS SQL 2000 DB in the above query,
>
> can any one let me know how this can be done?
>
> thankx,
> rushi
>

Look up Heterogeneous Connectivity.

-- 
Terry Dykstra 
Received on Tue Feb 13 2007 - 11:17:42 CST

Original text of this message

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