Using IS NULL or IS NOT NULL on join conditions - Theory question Using IS NULL or IS NOT NULL on join conditions - Theory question oracle oracle