Full outer join



How do I do a “full outer join” in Panoply?


Hi Steve,

To do a full outer join, write FULL JOIN or FULL OUTER JOIN and then specify an ON clause as you would normally.

Be aware that these can sometimes be expensive queries. We recommend against running full outer joins when possible.

If the result doesn’t immediately make sense, be sure to review SQL predicates and filters carefully.

See also the FROM Clause and Join examples entries in the Redshift Database Developer Guide.

For more on join types and performance considerations, these Stack Overflow discussions might be helpful: