OuterJoin Error in BODS

dataservices job design
1

Hi,

I am getting the following error when i have implemented the OuterJoin in Data Services:

[Query:Query]
Invalid query <Inner table <OE_ORDER_HOLDS_ALL> of an outer join is being joined with table <OE_ORDER_HEADERS_ALL>. Inner tables of an outer join cannot be involved in an inner join.>. (BODI-1111077)

I understood the error but ni idea on how to work around. Any thoughts.

Thanks,
Raghu.

BODI_USA (BOB member since 2010-11-14)

2

So you basically join 3 or more tables here.

You should either add the OE_ORDER_HOLDS_ALL as OUTER TABLE and OE_ORDER_HEADERS_ALL as the INNER TABLE in the Query Transform. I believe you will be already having a Outer Join condition there.

OR

You join both of these tables seperately first as a normal EQUI JOIN and then join the output of that query with the other table you would like to join.

ganeshxp :us: (BOB member since 2008-07-17)