Results 1 to 2 of 2

Thread: Join question

  1. #1
    Join Date
    Nov 2017
    Posts
    2

    Unanswered: Join question

    SQL Anywhere 17

    I have a view which contains this JOIN condition:

    JOIN s1_release
    LEFT OUTER JOIN gsr_release_load_balance
    ON s1_release.contract_nbr = gsr_release_load_balance.contract_nbr
    AND s1_release.release_nbr = gsr_release_load_balance.release_nbr
    ON s1_contract.contract_nbr = s1_release.contract_nbr

    Produces this error:
    Could not execute statement.
    Syntax error near 'ON' on line 208
    SQLCODE=-131, ODBC3 State="42000"
    Line 208

    This SQL has been ported from Oracle 11g and runs with no errors in an Oracle environment.

    "gsr_release_load_balance" is a view
    "s1_contract" is a table, contract_nbr is a primary key
    s1_release is a table, release_nbr is part of a primary key

    Can someone provide the SQL syntax SQL Anywhere is looking for??

    Thanks
    Murray

  2. #2
    Join Date
    Oct 2007
    Posts
    162
    Provided Answers: 9
    where is s1_contract in the SQL? Maybe share the rest of the query and we can help out.

Posting Permissions

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