• not sure from that explanation what exactly you want.

    But a note on outer joins that they will be overridden if you filter on an "outer" table in the where clause. So for a full outer join, you either want all your filtering in the ON, or you want to define the outer join in a derived table/cte, then select from it with a where clause.