topic Re: How to join in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join/m-p/3643263#M877342 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Use table LFA1 table to join with LFM1 by using primary key</P><P>LIFNR....</P><P></P><P>then use LFA1-ADRNR field to join with table ADRC...</P><P></P><P>Regards ,</P><P>Brijesh</P></BODY></HTML> Sat, 19 Apr 2008 11:25:41 GMT Former Member 2008-04-19T11:25:41Z How to join https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join/m-p/3643262#M877341 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have three tables LFM1,ADRC,ADR6,but there is no common field to join with LFM1,any one help me how to join these tables.</P><P></P><P>Thanks&amp;regds,</P><P>Sree.</P></BODY></HTML> Sat, 19 Apr 2008 11:16:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join/m-p/3643262#M877341 Former Member 2008-04-19T11:16:00Z Re: How to join https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join/m-p/3643263#M877342 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Use table LFA1 table to join with LFM1 by using primary key</P><P>LIFNR....</P><P></P><P>then use LFA1-ADRNR field to join with table ADRC...</P><P></P><P>Regards ,</P><P>Brijesh</P></BODY></HTML> Sat, 19 Apr 2008 11:25:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-join/m-p/3643263#M877342 Former Member 2008-04-19T11:25:41Z