I am new to this forum, so hello to everyone!!! Okay here it goes: I have two linked servers, one is oracle 9 and the other is mssql 2008. From mssql I am doing the following:

"SELECT * FROM OPENQUERY(PROD, 'SELECT * FROM A INNER JOIN B ON A.FID=B.ID;');"

I am getting the following error: OLE DB provider "MSDAORA" for linked server "PROD" returned message "ORA-00933: SQL command not properly ended


Any ideas? I am completely stuck.

You could always snap each or one to a temp table locally, then join locally.