Group selection made easy, Outer joins made powerful
Site owned & produced by MagnaFacta

The Full Outer Join Without Else Logic

You can filter a full outer join from an outer product without using Else Logic.

The query example

This is a standard outer join query, we only need the transformer for the outer product.

show all the people and all the companies - linked if applicable

Note that it is not a matter of not applying Else Logic, these subqueries cannot be shortened using Else Logic as their FROM does not refer to all the tables in the main query.

On the other hand we can see that this is a real outer join, as even the rows with invalid foreign keys are returned.

Conditions of use, Copyrights © & Intellectual Property Rights