select - endselect

Dear all,i have this statment

select * from mkol where matnr eq intab-matnr and lgort in tem.

if.....endif.

endselect.

and it is working fine,but if i use the following statement,then it str8 go to endselect without go thru the if endif block.

select * from mkol where matnr eq intab-matnr and lgort in tem and not lgort in temc and not logrt in tempd.

if....endif.

endselect.

wat has gone wrong? previously i used in other program,it works,but this time it din work...pls help..thanks