New Join Types Discovered

Posted by Tom

on Tuesday, August 5. 2008

I spent a good chunk of my day today reworking SQL queries, and while doing so I discovered two join types I'd never encountered before.

• The INNERT JOIN is guaranteed to produce no rows. It is useful when you want to be sure your query does nothing, i.e. it's inert.

• The LEFT OVER JOIN returns any rows that would not have been returned by a LEFT OUTER join, i.e. rows that were... well, left over.

I think I need to take a break...

Databases (General)

Trackbacks

Trackback specific URI for this entry

Links for the Week | Full Table Scan | 08 Aug, 15:17

Ok, so at this point, the best I can do is bad jokes and link collections. Real content will resume next week. I hope. • "The Drizzle project is building a database optimized for Cloud and Net applications. It is being designed for massive concu

Comments

Joe Harris on 2008-08-06 06:59 | Reply

This is the funniest thing I've read in ages. I was nearly crying.
Guess that makes me a database geek...