you can always use a=1 to a, a=0 to not a but you can also do from if (a=1 and b=1) and salary=updated_salary then flag='No change'; if a=1 and b=0 then flag='No change'; to if ((a=1 and b=1) and salary=updated_salary) or ( a=1 and b=0) then flag='No change';
Пікірлер: 3