Do you know how I return a value in a select statement when an outer join is null....
I want to set a default value for a column when an outer join fails (+)
Select a.id, b.address
from member a , address b
a.member_id = 1
and a.member_id = b.member_id ( + )
default address when outer join fails.