I'm also pretty sure that, even across a linked server, Oracle defaults to being case-sensitive for all things like table names, column names, etc, ad infinitum (just to cover the next possible error that I see coming up).

--Jeff Moden"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T."--22 Aug 2013

Yes.If i replace the top n with select * and leave the rest of the script the same I get a lot of records back.The error exist only if i have more than a few tables in the join and use top nTake top n out and i can join on as many tables as i want.

Are all the tables used in the Join located at the Orcle server?If so, I recommend to change it to a remote Query (at least for all tables located at the Oracle server).In that remote query yo should use ROWNUM<100 again, since it'll be executed using Oracle syntax.