Comment by zzzeek

we who use these databases for real problems need LEFT OUTER JOIN and to use LEFT OUTER JOIN you need NULL.