topic Join Condition in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2615978#M600474 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>I have to join the two infotypes data i.e pa0002,pa0008.</P><P>pa0002-nachn</P><P>pa0008-ansal</P><P>In that which primary key i taken ?</P><P></P><P>Thanks</P><P>Sree</P></BODY></HTML> Wed, 08 Aug 2007 10:15:34 GMT Former Member 2007-08-08T10:15:34Z Join Condition https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2615978#M600474 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>I have to join the two infotypes data i.e pa0002,pa0008.</P><P>pa0002-nachn</P><P>pa0008-ansal</P><P>In that which primary key i taken ?</P><P></P><P>Thanks</P><P>Sree</P></BODY></HTML> Wed, 08 Aug 2007 10:15:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2615978#M600474 Former Member 2007-08-08T10:15:34Z Re: Join Condition https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2615979#M600475 <HTML><HEAD></HEAD><BODY><P>the following keys can be matched for both the tables...</P><P>PERNR</P><P>SUBTY</P><P>OBJPS</P><P>SPRPS</P><P>ENDDA</P><P>BEGDA</P><P>SEQNR</P></BODY></HTML> Wed, 08 Aug 2007 10:20:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2615979#M600475 Former Member 2007-08-08T10:20:03Z Re: Join Condition https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2615980#M600476 <HTML><HEAD></HEAD><BODY><P>just write the select stmt to join these infotypes....</P></BODY></HTML> Wed, 08 Aug 2007 10:21:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2615980#M600476 Former Member 2007-08-08T10:21:07Z