How do I do a “full outer join” in Panoply?
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.
For more on join types and performance considerations, these Stack Overflow discussions might be helpful: