Join egghead, unlock knowledge.

Want more egghead?

This lesson is for members. Join us? Get access to all 3,000+ tutorials + a community with expert developers around the world.

Unlock This Lesson
Become a member
to unlock all features

Level Up!

Access all courses & lessons on egghead today and lock-in your price for life.


    Join Tables in Postgres with Complex Conditions


    While our data is sometimes nicely managed with surrogate primary key joins, often times older tables can feature join conditions with complex natural keys.