Skip to Content
0
May 21, 2010 at 09:04 AM

Nested select

38 Views

Hi All,

I need syntax to select data from a table which will have a nested select query.

mblnr mjahr zeile matnr werks sjahr smbln

4900000276 2010 0001 000000000000000131 1000 0000

4900000277 2010 0001 000000000000000131 1000 0000

4900000278 2010 0001 000000000000000131 1000 2010 4900000277

4900000279 2010 0001 000000000000000131 1000 2010 4900000276

4900000280 2010 0001 000000000000000131 1000 0000

I want if I input material no as input I should get o/p as one row which is 4900000280.

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.

Regards,

Anil N.