OUTER JOIN

Former Member — Mon, 09 Jun 2008 10:25:37 GMT

Hi to all

can i use left outer join n then use for all entries to fetech the rest of the data. i am developing sales register report ( i.e. complete flow ) contract -> sales order - > delivery - > token - > pgi -- > invoice. the problem is if i populate contract first in itab then i can not insert multiple Sales order against those contract. so in this case can i use outer join or is there any other way to resolve this problem.

thnx

Fozia

Re: OUTER JOIN

Former Member — Mon, 09 Jun 2008 10:43:49 GMT

Hi,

Make sure u'll get the necessary data use left outer join- specify the condition properly. and u can as well join the table to get all the relevant data in one step, instead of having for all entries.

regards,

madhu

topic OUTER JOIN in Application Development and Automation Discussions

OUTER JOIN

Re: OUTER JOIN