I just sent support a protocol (it's attached here) illustrating how you can get screwed up when you do a join on records that have nulls in properties. I've suggested that NULLs be considered to be an actual value (of NULL, I guess) when doing joins so that the join doesn't automatically fail.

Anybody else surprised by this?