topic Nested select in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/nested-select/m-p/6870120#M1477045 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need syntax to select data from a table which will have a nested select query.</P><P>mblnr mjahr zeile matnr werks sjahr smbln</P><P>4900000276 2010 0001 000000000000000131 1000 0000</P><P>4900000277 2010 0001 000000000000000131 1000 0000</P><P>4900000278 2010 0001 000000000000000131 1000 2010 4900000277</P><P>4900000279 2010 0001 000000000000000131 1000 2010 4900000276</P><P>4900000280 2010 0001 000000000000000131 1000 0000</P><P></P><P>I want if I input material no as input I should get o/p as one row which is 4900000280.</P><P></P><P>I need to skip those records where sjahr,smbln contains any value and also the value it contains should not be selected as smbln contains 4900000277 and 4900000276 as mblnr.</P><P></P><P>Regards,</P><P>Anil N.</P></BODY></HTML> Fri, 21 May 2010 09:04:49 GMT former_member438956 2010-05-21T09:04:49Z Nested select https://community.sap.com/t5/application-development-and-automation-discussions/nested-select/m-p/6870120#M1477045 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need syntax to select data from a table which will have a nested select query.</P><P>mblnr mjahr zeile matnr werks sjahr smbln</P><P>4900000276 2010 0001 000000000000000131 1000 0000</P><P>4900000277 2010 0001 000000000000000131 1000 0000</P><P>4900000278 2010 0001 000000000000000131 1000 2010 4900000277</P><P>4900000279 2010 0001 000000000000000131 1000 2010 4900000276</P><P>4900000280 2010 0001 000000000000000131 1000 0000</P><P></P><P>I want if I input material no as input I should get o/p as one row which is 4900000280.</P><P></P><P>I need to skip those records where sjahr,smbln contains any value and also the value it contains should not be selected as smbln contains 4900000277 and 4900000276 as mblnr.</P><P></P><P>Regards,</P><P>Anil N.</P></BODY></HTML> Fri, 21 May 2010 09:04:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/nested-select/m-p/6870120#M1477045 former_member438956 2010-05-21T09:04:49Z Re: Nested select https://community.sap.com/t5/application-development-and-automation-discussions/nested-select/m-p/6870121#M1477046 <HTML><HEAD></HEAD><BODY><P>Hi, Anil </P><P></P><P>Please get F1 help of Select and find out the Sub Query Example. It will solve out your problem.</P><P></P><P>Best Regards,</P><P>Faisal</P></BODY></HTML> Fri, 21 May 2010 09:11:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/nested-select/m-p/6870121#M1477046 faisalatsap 2010-05-21T09:11:41Z