OPENQUERY with JOIN problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

OPENQUERY with JOIN problem

Author

Topic

korssane
Posting Yak Master

104 Posts

Posted - 2009-10-14 : 16:19:07

Hi all,

i was already helpe visakh16,
Can some one help me do an openquery join of local table1 ( SQL 2005 server )with a table in Oracle that is accessible via the Open query.

thanks to visakh16 he already helped me but i am still experiencing the same problem.

** What i want basically is to pull (ct.TRID,fe.RE_ID, fe.EVME) from an Oracle table using openquery where the (ct.TRID = AEA.KEYID)...
** AEA.KEYID is a field in a local Table in a SQL2005 server.

Any help will be more than appreciated.. thanks

here is my code :

SELECT columns...
FROM
(
SELECT * FROM OPENQUERY(LINKED_ORA,
'SELECT
ct.TRID,
fe.RE_ID,
fe.EVME

FROM ORA_TABLE1@db5 fe,
ORA_TABLE2@db5 ct

WHERE

ct.TRID = fe.KELD
AND lower(ct.CAT1) NOT LIKE ''%kawa%''

AND (
fe.EVME LIKE ''%Link to Known Issue''
OR fe.EVME LIKE ''%Unlink Known Issue''

)')
)AS OPQ
JOIN SQLTABLE1 AEA ON AEA.KEYID= OPQ.TRID

*****

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources