Re: Left join help

[Arup Rakshit <aruprakshit1987@xxxxxxxxxxx>]

Hi David,

Can you tell me how can I add ordering between LEFT and INNER JOIN. I think also that is where I am wrong, but not sure how to correct the ordering.

Thanks,

A

On Jun 24, 2017, at 3:18 AM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Friday, June 23, 2017, Arup Rakshit <aruprakshit1987@xxxxxxxxxxx> 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.