topic Re: regarding SQL query in Application Development and Automation Discussions

regarding SQL query

Former Member — Fri, 19 Oct 2007 04:38:59 GMT

hi all,

I have got one query very i need to check for an field condition based,that is for field1 eq ='ABC' and field1 eq 'dcf' with other conditions as well.

So please tell me how to do it in only one sql statement.

code is as follows:

SELECT RBUKRS RACCT RZZSLOB RZZBSA RBLART RMVCT FROM ZDLC2T INTO TABLE it_fndtab

WHERE RYEAR EQ p_year AND RBUKRS IN s_comp and ( RBLART EQ 'ZS' and RBLART EQ 'ZQ' ).

Thanks in Advance.

Reward points given

Re: regarding SQL query

Former Member — Fri, 19 Oct 2007 04:45:07 GMT

Hi,

Check out this code.

SELECT RBUKRS RACCT RZZSLOB RZZBSA RBLART RMVCT FROM ZDLC2T INTO TABLE it_fndtab

WHERE RYEAR EQ p_year AND RBUKRS IN s_comp and RBLART in ( 'ZS' , 'ZQ' ).

regards,

Santosh Thorat

Re: regarding SQL query

Former Member — Fri, 19 Oct 2007 04:46:58 GMT

Hi Aruna,

Please use the or statement.

RBLART EQ 'ZS'

RBLART EQ 'ZQ'

Hope this helps.

Benedict