Get the join cheat sheet!

Download and print this nifty little PDF with all of the INNER, LEFT, RIGHT, FULL and CROSS JOINs visualized! It’ll look great on your office wall or cubicle. Your coworkers and your interior decorator will love you for it.

How it works: For each join example, there are two tables, the left and the right table, shown as two columns. For the sake of simplicity, these tables are called “a” and “b” respectively in the code.

You’ll notice that the sheet uses a kind of pseudo-code when it comes to table names and column names.

8 thoughts on “Get the join cheat sheet!

  1. Pingback: Visualizing Types Of Joins – Curated SQL

  2. Pingback: Links harvested from other collections of links… – Various and sundry bits

  3. Pingback: Database JOIN cheat sheet – Istari Consulting LLC

  4. Pingback: Video: Venn Diagrams are for Sets, NOT Joins! – 36 Chambers – The Legendary Journeys: Execution to the max!

Let me hear your thoughts!

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.