I think Pablo means use OPENQUERY on just the Oracle table, not all tables - it definitely won't work on all tables as it can't see the SQL tables when it runs remotely on the Oracle srever.... also FYI, you need to escape-quote your OPENQUERY string - note that your dates and stuff arent coloured correctly when syntax highlighted.

So try this:

SELECT U.ABO, U.LED_ID, U.PROJECT_NO, T.WORDC, P.CHECKC, P.PIN_NO

FROM unit1 U

INNER JOIN unit2 L

ON U.ABO = L.ABO

INNER JOIN

(

SELECT CT_ID, CHECKC, PIN_NO FROM

OPENQUERY(LS,'SELECT CT_ID, CHECKC, PIN_NO FROM USER2.UNIT3')

) P

ON L.CT_ID = P.CT_ID

INNER JOIN unit4 T

ON U.PCT = T.ACT

AND U.FJT_TYP = T.FJT_TYP

WHERE U.ABO like 'LE%'

AND U.CREATE_DT = '2009-01-18'

Looking at the Oracle error info, maybe its trying to do something smart for thel inked server- but it's not smart enough.

Also I have removed the ORDER BY for now to help isolate the problem.

Does it work if you use a different value for U.CREATE_DT?