Did you know ... Search Documentation:
Left Outer Join