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

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 Received on Tue Feb 13 2007 - 11:06:17 CST