Re: Can't seem to mix an inner and outer join in a query and get it to work right.

The convention here is to bottom post or inline responses.

On Wed, Jul 1, 2020 at 9:51 AM David Gauthier <davegauthierpg(at)gmail(dot)com>
wrote:

> Actually, I want the outer join first. If it finds something, then move
> on to the inner join and filter out all those that don't join to a rec with
> 'autosmoke'. But if the outer join does not connect to the workarea_env
> table, then just return what you have (the purpose of the outer join)
>
>>
>>>
So your final result - ignoring columns - is basically:
(sqf, (workarea, events))

where either the entire (workarea, events) is null, or if it is
non-null then workarea must also be non-null

Thus: ((workarea is left joined against events) with the whole thing left
joined against sqf). And we are back to the join ordering precedence since
what you originally wrote was ((sqf, workarea), events).

In short - two outer joins; you can work out precedence either with
syntactic order or parentheses.

David J.