topic Re: getting multiple values in join statement! in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/getting-multiple-values-in-join-statement/m-p/3193261#M760840 <HTML><HEAD></HEAD><BODY><P>Ofcourse u can get, fetch all values that forms unique records.</P><P></P><P>If u use for all entries and fetch only vbeln, it will automatically delete the duplicates. so the technique is use vbeln, posnr and other fields that forms unique</P></BODY></HTML> Wed, 12 Dec 2007 07:08:04 GMT Former Member 2007-12-12T07:08:04Z getting multiple values in join statement! https://community.sap.com/t5/application-development-and-automation-discussions/getting-multiple-values-in-join-statement/m-p/3193260#M760839 <HTML><HEAD></HEAD><BODY><P>Hey friends,</P><P> I have written a join statement where I have joined multiple tables because I want to fetch data from different fields. Against Vbeln i am supposed to get the values of other fields!</P><P></P><P> Is it possible to get multiple records against one VBELN.?</P><P> I know i should not use join but for all entries but i am just asking whether i am supposed to get multiple values or not !</P></BODY></HTML> Wed, 12 Dec 2007 07:02:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/getting-multiple-values-in-join-statement/m-p/3193260#M760839 Former Member 2007-12-12T07:02:29Z Re: getting multiple values in join statement! https://community.sap.com/t5/application-development-and-automation-discussions/getting-multiple-values-in-join-statement/m-p/3193261#M760840 <HTML><HEAD></HEAD><BODY><P>Ofcourse u can get, fetch all values that forms unique records.</P><P></P><P>If u use for all entries and fetch only vbeln, it will automatically delete the duplicates. so the technique is use vbeln, posnr and other fields that forms unique</P></BODY></HTML> Wed, 12 Dec 2007 07:08:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/getting-multiple-values-in-join-statement/m-p/3193261#M760840 Former Member 2007-12-12T07:08:04Z