Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    1

    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.

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    You could always snap each or one to a temp table locally, then join locally.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •