SELECT e.name,b.bonusFROM Employee eLEFT JOIN Bonus bON e.empId = b.empIdWHERE IFNULL(b.bonus,0)<1000;