Go ProSign in

Find Postgres Data That Doesn’t Match Join Conditions with Full Outer Join

What if we want to see all Kickstarter projects with backers, plus projects that have no backers, plus backers that have no projects? We can use full outer join for that. In the wild, full outer join, left join, and right join will most often be used for orphan detection.

You must be a Member to view code