Re: 8 Join Table... Access to Oracle... Think your good? Try and Master this one!

mgillesp_at_uoguelph.ca wrote:

> Oracle:
>
> WHERE
>
> WHERE
> B_DATA_FROM_SPECIMNS.HSBJ_ID = EMHEALTH_SUBJECT_TYPE.HSBJ_ID(+)
> AND
> B_DATA_FROM_SPECIMNS.SPECIMN_ID = B_COLLECTION_PT.SPECIMN_ID(+)
> AND
> B_DATA_FROM_SPECIMNS.SPECIMN_ID =
> B_GET_PROD_DATA_CROSSTAB.SPECIMN_ID(+)
> AND
> PERSON.GENDER_ID = RD_GENDER.VALUE_ID(+)
> AND
> ANML_HSBJ.GENDER_ID=RD_GENDER_1.VALUE_ID(+)
> AND
> HMN_HSBJ.PERSON_ID=PERSON.PERSON_ID(+)
> AND
> HMN_HSBJ.HSBJ_ID(+)=EMHEALTH_SUBJECT_TYPE.HSBJ_ID
> AND
> ANML_HSBJ.HSBJ_ID(+)=EMHEALTH_SUBJECT_TYPE.HSBJ_ID
>
>
> Now some of the Right and Left Joins are mixed up between the Oracle
> and Access versions, but I think they did this because Oracle doesn't
> allow two outer joins on the same table in one query.

Sure it does. You just need to code in-line views and then join them.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org