outer join migration problem in BODS 4.1

[former_member214617]

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

[former_member187605]

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

[former_member187605]

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.

[former_member214617]

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