Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: joining table from oracle db to a table in ms sql db
"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 DykstraReceived on Tue Feb 13 2007 - 11:17:42 CST