Skip to Content
Former Member
Oct 30, 2009 at 07:14 AM

Regarding Inner join query


Hi Guriji,s

I wrote one inner join query. it is working fine. but when i exceute this query it is fetching the data only 261 movement type but but i also fetch the data movement type 201. for this plz tell me the correction in this query.

select amatnr awerks abwart bbudat into table t_itab from mseg as a inner join mkpf as b

on amblnr = bmblnr

where awerks in plant and abwart = '261' or a~bwart = '201'

and btcode2 = 'mb1a' or btcode2 = 'mfbf' .