Understand Joins and Unions in Postgres by Brett Cassette

• Find Postgres Data That Doesn’t Match Join Conditions with Full Outer Join
• Find Lonely Postgres Data with Left and Right Join
• Detect Duplicates in Postgres with Cartesian Product
• Find Related Data with Inner Join in Postgres
• See All Rows from Different Postgres Tables with Union All
• Join Tables in Postgres with Complex Conditions
• Create a History Table in Postgres with Joins
• Use Joins to Detect Orphaned Data in Postgres