Skip to Content

outer join migration problem in BODS 4.1

Hi guys

i have one job built in XI R3 which got multiple left outer join between different tables when i imported same in BODS 4.1 then the tables are not joined properly...

I have attached images from XIR3 and 4.1

in BODS 4.1 it is alowing only to select table in the starting.. not allowing me to select the different table on left hand side..

can you tell me how it can be possible in BODS 4.1.

let me know if you need more information

thanks & regards

join_4.1.gif (8.4 kB)
join_XIR3.gif (5.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 10, 2014 at 02:34 PM

    The join is not determined by the order in which you specify the tables, but by the join conditions themselves. So both XI3 and 4.1 representations are valid and will lead to the same results.

    Add a comment
    10|10000 characters needed characters exceeded


    • thanks Dirk for replying... i am not talking about order of the join... my problem is in 4.1 i am allowed to select only 1 table in the beginning on the left hand side and if i want to select another table in next row on left hand side where right now arrow is showing...

      when i see optimized sql from validation menu option then it is showing multiple sql queries rather than having one single query...

      let me know if you need more information

      regards

  • Posted on Jan 13, 2014 at 08:21 AM

    Just specify the tables you want to join to on right hand side. And do not forget to specify the join conditions:

    The generated sql:

    SELECT T4.C1 , T3.C2 , T2.C3

    FROM DBO.T1

    INNER JOIN DBO.T2 ON T1.C1 = T2.C2

    LEFT OUTER JOIN DBO.T3 ON T2.C2 = T3.C1

    LEFT OUTER JOIN DBO.T4 ON T3.C2 = T4.C2 AND T3.C3 = T4.C3


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.