I recently had to explain to some people the difference between the different kinds of SQL joins. Now I have been using SQL for well over 15 years and feel myself quite the expert, however this stumped me like a number 10 batsmen facing an Alan Donald yorker. The problem [...]