Re: outer join

You are right about the union. This is a solution I received in another newsgroup.

select DISTINCT c.ctac_id, v.street from contact c, (select ctac_id, street from off_addr oa, address a  where oa.addr_id = a.addr_id
 union all
 select ctac_id, street from contact_addr ca, address a  where ca.addr_id = a.addr_id
) v
where c.ctac_id = v.ctac_id(+)

Thanks for your response

--
Jim Poe ( jpoe_at_fulcrumit.com )