var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Joining tables in OPENQUERY
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.