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.
Pingback: Visualizing Types Of Joins – Curated SQL
Pingback: Links harvested from other collections of links… – Various and sundry bits
cross join alternative : from a cross apply (select * from b) b
I might do an entire new PDF on APPLY patterns someday. :)
Nice! Thank you.
Thanks! Glad you like it. :)
Pingback: Database JOIN cheat sheet – Istari Consulting LLC
Pingback: Video: Venn Diagrams are for Sets, NOT Joins! – 36 Chambers – The Legendary Journeys: Execution to the max!