IF CONDITION

Hi to make if condition with two different tables? this is the command

EXTRACT USERS_ROLE RUSERS_USERID USERS_FR_CCROLE IF (USERS_EFFECTIVE_TO >%_v_Cutoff%) AND (A1_USER_PROFILE.USR02_USERID <> " ") TO A2_USER_ROLES