577. Employee Bonus

SELECT e.name,b.bonus
FROM Employee e
LEFT JOIN Bonus b
ON e.empId = b.empId
WHERE IFNULL(b.bonus,0)<1000
;

posted @ 2018-12-23 02:48  yuesi  阅读(133)  评论(0编辑  收藏  举报