On Friday, June 23, 2017, Arup Rakshit <
aruprakshit1987@outlook.com> wrote:
FROM "missions" LEFT JOIN submissions ON submissions.mission_id =
missions.idINNER JOIN members ON
members.id = submissions.member_id
Quick look here but having submissions as part of the inner join with members defeats the attempt at left joining it with missions. You might need to add parentheses to put the joins in the correct order, or something. Why it gives zero results we cannot say without a self-contained example.
David J.