Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

How to join multiple tables using outer joins !

Former Member

‎2007 Dec 17 6:39 AM

0 Likes
442

Please Any one help me ....how to join more than three tables

using left outer joins So that E.g

if I am joining tables A,B,C,D etc

and A has vbeln then I should get the output of this join in such a way that I will get all the values of vbeln on the left in the final table but corresponding field values in the final table

may or may not present. If B,C,D.... has the values of other filelds corresponding to vbeln then they will be dislayed other wise blank....

Please Any one help me ....how to join more than three tables

using left outer joins So that E.g

if I am joining tables A,B,C,D etc

and A has vbeln then I should get the output of this join in such a way that I will get all the values of vbeln on the left in the final table but corresponding field values in the final table

may or may not present. If B,C,D.... has the values of other filelds corresponding to vbeln then they will be dislayed other wise blank....

Reply
2 REPLIES 2
Read only

Former Member

‎2007 Dec 17 6:42 AM

0 Likes
422

joining vbap outer join vbep and if there is no corresponding record i vbep, you will still get a record from vbap.

Read only

Former Member
In response to Former Member

‎2007 Dec 17 7:41 AM

0 Likes
422

SEND ME AN EXAMPLE OF LEFT OUTER JOIN WITH MORE THAN 4 TABLES