Did you know ... Search Documentation:
Retrieved nulls have special logic to handle outer joins