Skip to Content
0
Former Member
Feb 28, 2007 at 07:06 PM

help needed in rewriting the code using inner joins

20 Views

Hi all,

I need help in rewriting this code

DATA : FLD LIKE ZTABLE-ZFLD,

FLD1 LIKE ZTABLE2-ZFLD2.

select single ZFLD from zTABLE1 into FLD

where MATNR = '123' and

werks = 'ABC'.

select single ZFLD1 from zTABLE2 into FLD1

where zFLD = FLD.

iS there way that we can write this with inner joins

Thanks