topic Re: How to join multiple tables using outer joins ! in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join-multiple-tables-using-outer-joins/m-p/3204913#M764009 <HTML><HEAD></HEAD><BODY><P>SEND ME AN EXAMPLE OF LEFT OUTER JOIN WITH MORE THAN 4 TABLES</P></BODY></HTML> Mon, 17 Dec 2007 07:41:13 GMT Former Member 2007-12-17T07:41:13Z How to join multiple tables using outer joins ! https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join-multiple-tables-using-outer-joins/m-p/3204911#M764007 <HTML><HEAD></HEAD><BODY><P>Please Any one help me ....how to join more than three tables</P><P>using left outer joins So that E.g </P><P>if I am joining tables A,B,C,D etc</P><P>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</P><P>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....</P></BODY></HTML> Mon, 17 Dec 2007 06:39:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join-multiple-tables-using-outer-joins/m-p/3204911#M764007 Former Member 2007-12-17T06:39:48Z Re: How to join multiple tables using outer joins ! https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join-multiple-tables-using-outer-joins/m-p/3204912#M764008 <HTML><HEAD></HEAD><BODY><P>joining vbap outer join vbep and if there is no corresponding record i vbep, you will still get a record from vbap.</P></BODY></HTML> Mon, 17 Dec 2007 06:42:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join-multiple-tables-using-outer-joins/m-p/3204912#M764008 Former Member 2007-12-17T06:42:56Z Re: How to join multiple tables using outer joins ! https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join-multiple-tables-using-outer-joins/m-p/3204913#M764009 <HTML><HEAD></HEAD><BODY><P>SEND ME AN EXAMPLE OF LEFT OUTER JOIN WITH MORE THAN 4 TABLES</P></BODY></HTML> Mon, 17 Dec 2007 07:41:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join-multiple-tables-using-outer-joins/m-p/3204913#M764009 Former Member 2007-12-17T07:41:13Z