topic Regarding Inner join query in Application Development and Automation Discussions

Regarding Inner join query

Former Member — Fri, 30 Oct 2009 07:14:18 GMT

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 a_{matnr a}werks a_{bwart b}budat into table t_itab from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr

where a_{werks in plant and a}bwart = '261' or a~bwart = '201'

and b_{tcode2 = 'mb1a' or b}tcode2 = 'mfbf' .

thanks.

Re: Regarding Inner join query

Former Member — Fri, 30 Oct 2009 07:15:59 GMT

Hi,

Change OR to AND in the where clause condition of the query

Vikranth

Re: Regarding Inner join query

kesavadas_thekkillath — Fri, 30 Oct 2009 07:17:31 GMT

Code like this


select a~matnr a~werks a~bwart b~budat into table t_itab 
from mseg as a inner join mkpf as b on a~mblnr = b~mblnr
where a~werks in plant 
and a~bwart in('261','201')
and b~tcode2 in ('mb1a','mfbf') .

Re: Regarding Inner join query

praveen_hannu — Fri, 30 Oct 2009 07:20:33 GMT

Hi Sachin

try to use like below

select a_{matnr a}werks a_{bwart b}budat into table t_itab from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr

where a_{werks in plant and ( a}bwart = '261' or a~bwart = '201' )

and ( b_{tcode2 = 'mb1a' or b}tcode2 = 'mfbf' ).

or try to fill ranges like select-options or use like

select a_{matnr a}werks a_{bwart b}budat into table t_itab from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr

where a_{werks in plant and a}bwart in ('261', '201')

and b_{tcode2 = 'mb1a' or b}tcode2 = 'mfbf' .

Regards

Praveen

Re: Regarding Inner join query

Former Member — Fri, 30 Oct 2009 07:21:16 GMT

HI ,

U write as like this

select a_{matnr a}werks a_{bwart b}budat into table t_itab from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr

where a_{werks in plant and ( a}bwart = '261' or a~bwart = '201 ' )'

and b_{tcode2 = 'mb1a' or b}tcode2 = 'mfbf' .

Thanks

Shambhu

Re: Regarding Inner join query

Former Member — Fri, 30 Oct 2009 07:21:36 GMT

HI ,

U write as like this

select a_{matnr a}werks a_{bwart b}budat into table t_itab from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr

where a_{werks in plant and ( a}bwart = '261' or a~bwart = '201 ' )'

and ( b_{tcode2 = 'mb1a' or b}tcode2 = 'mfbf )' .

Thanks

Shambhu