Re: outer join

How are the relations defined among the tables: one2many, etc?

You probably not only need outer join, but also a UNION because you have two different relation tables.

BTW, I am trying to understand what OFFICE_ADDR_ID and CTAC_ADDR_ID in your model do. Are they related to other tables not listed here? Also, are OFFICE address and contact address mutually exclusive?

In article <92tagd$atn_at_dispatch.concentric.net>,   "Jim Poe" <jpoe_at_fulcrumit.com> wrote:
> 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 )
>
>

--
Jining Han
Sallie Mae


Sent via Deja.com
http://www.deja.com/