Full outer join

Jason Harris

• June 11, 2018 20:52

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

0

• 

  Alon Brody

  • June 11, 2018 20:54

  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:

  • INNER JOIN vs LEFT JOIN performance in SQL Server
    
  • What is the difference between “INNER JOIN” and “OUTER JOIN”?

  0

Please sign in to leave a comment.