• Thanks a lot for your reply.

    We don't have any CLOB/BLOBS columns in the oracle tables.. Since our application code is already written and we are testing the linked server with this code, we are trying as much not to change the queries so it reduces huge amount of time altering all the queries in the code.. Is there anything else that we could do to make this work without altering the query? Like may be change the format etc..

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

    FROM unit1 U, unit2 L, LS..USER2.UNIT3 P, unit4 T

    WHERE

    U.ABO like 'LE%'

    AND U.CREATE_DT between '01/18/2009' and '04/20/2009'

    AND U.ABO = L.ABO

    AND L.CT_ID = P.CT_ID AND U.PCT = T.ACT AND U.FJT_TYP = T.FJT_TYP

    ORDER BY U.ABO, U.LED_ID

    The above query & the query that you posted using the inner join works only if I remove the order by clause or if I remove one of the where clause condition. Is this a limitation in linked server?

    Thanks again.