select e.name, b.bonus
from employee as e left join bonus as b on e.empId = b.empId
where b.bonus < 1000 or b.bonus is null
null需要用is或is not来进行判断
select e.name, b.bonus
from employee as e left join bonus as b on e.empId = b.empId
where b.bonus < 1000 or b.bonus is null
null需要用is或is not来进行判断