outer join

I have the following four tables:
Contact
  CTAC_ID Office_Addr
  OFFICE_ADDR_ID
  CTAC_ID
  ADDR_ID Contact_Addr

  CTAC_ADDR_ID
  CTAC_ID
  ADDR_ID

Address
  ADDR_ID
  STREET Office_Addr and Contact_Addr are details of Contact. Address is a detail for both Office_Addr and Contact_Addr.

I want to create a view that contains CTAC_ID and STREET for all contacts. It should contain a row for each contact's street whether it is an office address or a contact address. It should also contain a single row if the contact has no address. Can this be done?

--
Jim Poe ( jpoe_at_fulcrumit.com )