On Friday, June 23, 2017, Arup Rakshit <aruprakshit1987(at)outlook(dot)com> wrote:
>
> FROM "missions" LEFT JOIN submissions ON submissions.mission_id =
> missions.id
> INNER 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.