Hello,
Your join is causing issues.
SELECT t.id, s.firstname,s.lastname, t.effort
FROM taskeffort t
LEFT OUTER JOIN student s ON s.studentid = t.studentid
WHERE t.id = 4
If you want to get only task id = 4 records, it should be added in WHERE clause.
RelicV