help in select statment

Hallow I have select statement and if sy-subrc ne to 0 it it don’t do the else statement why? how can I solve it?

Regards

LOOP AT mb_emp_tab INTO wa_mb_emp_tab.

SELECT stdaz plans pernr " Employee Numbers & Hours

FROM pa2010

INTO (wa_mb_emp_tab-no_of_hours_mb, wa_mb_emp_tab-plans, wa_mb_emp_tab-pernr)

• FOR ALL ENTRIES IN mb_emp_tab

WHERE pernr = wa_mb_emp_tab-pernr

AND lgart = '9EXT' " Wage Type (salary)

AND begda GE end_date_mounth

AND begda LE start_date_mounth

GROUP BY stdaz plans pernr.

if sy-subrc = 0.

IF wa_mb_emp_tab-no_of_hours_mb IS NOT INITIAL.

wa_mb_emp_tab-part_emp = ( wa_mb_emp_tab-no_of_hours_mb / 185 ).

APPEND wa_mb_emp_tab TO mb_emp_tab2.

MODIFY mb_emp_tab FROM wa_mb_emp_tab

TRANSPORTING part_emp no_of_hours_mb plans.

CLEAR wa_mb_emp_tab.

<b> ELSE.</b>

ADD 1 TO wa_mb_emp_tab-part_emp .

ADD 185 TO wa_mb_emp_tab-no_of_hours_mb.

MODIFY mb_emp_tab FROM wa_mb_emp_tab

TRANSPORTING part_emp no_of_hours_mb plans.

CLEAR wa_mb_emp_tab.

ENDIF.

ENDSELECT.

ENDLOOP.

i dont wont to remove the end select before the if statment becouse

sometime i have in the if more then 1 recored

regards