regarding SQL query
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