Fork me on GitHub

When is a JOIN not a JOIN and what is a black box?

You probably heard this one as a kid right? No? Well the answer to the riddle is this: when one is a LEFT JOIN, one is an INNER JOIN and you are using a certain RDBMS named Sybase. So I recently heard of a situation with Sybase where a LEFT JOIN on a particular key ...