topic Re: Error showing while left join in Application Development and Automation Discussions

Error showing while left join

Former Member — Wed, 05 Nov 2008 09:52:29 GMT

Dear expert,

can we use both sides table in where condition of any

outer join?

can you give me an example.

i want to create one left join for one view and one std. table.

i want to give some condition for both table , and it is depended on selection critera.

but it is giving error to me that can not use right side table in left outer join.

when i remove left join and put inner joint it's worked or when i put comment on tht perticular critrea then also it works but when i put that condition with outer joins then it will work.

please help me.

thanks

Re: Error showing while left join

Former Member — Wed, 05 Nov 2008 10:21:02 GMT


>can not use right side table in left outer join. 
>

Unfortunatly it is true and is limitation of ABAP Left Outer Join.

(Oracle, SQL Server 2000/2005, etc database Native SQL outer join statement supports this)

You need to loop through the internal table to further

filter records based on right side table.

Regards,

Vishal

Re: Error showing while left join

Former Member — Fri, 20 Mar 2009 10:02:34 GMT

not possible in ABAP