Re: Oracle View and Crystal Reports

On Apr 25, 2:14 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> cory.swartz schreef:
>
>
>
>
>
> > From
> > CMDSERIES.ORDR,CMDSERIES.ORDL,CMDSERIES.PROJ,CMDSERIES.EMPL,CMDSERIES.PLNT
> > WHERE
> > ((CMDSERIES.ORDR.CUST_CODE=CMDSERIES.PROJ.CUST_CODE)
> > AND(CMDSERIES.ORDR.ORDER_DATE=CMDSERIES.ORDL.ORDER_DATE)
> > AND(CMDSERIES.ORDR.PROJ_CODE=CMDSERIES.PROJ.PROJ_CODE)
> > AND(CMDSERIES.ORDR.ORDER_CODE=CMDSERIES.ORDL.ORDER_CODE)
> > AND(CMDSERIES.ORDR.SLSMN_EMPL_CODE=CMDSERIES.EMPL.EMPL_CODE)
> > AND(CMDSERIES.ORDR.PRICE_PLANT_CODE=CMDSERIES.PLNT.PLANT_CODE))
> > =============================================
>
> > The issue I have is there are records in the ORDR table that do not
> > have an ORDR.PROJ_CODE value. I still want to display these values in
> > my report, but they do not show up. When I remove the
> > AND(CMDSERIES.ORDR.PROJ_CODE=CMDSERIES.PROJ.PROJ_CODE) line from the
> > view, I get tons of repeating values. I've tried outer joins, but to
> > no avail. I'm lost at this point and any assistance would be greatly
> > appreciated.
>
> > Thanks.
>
> Use an outer join; the plus sign comes on the missing data
> side of the equasion: CMDSERIES.ORDR.PROJ_CODE=ORDR.PROJ_CODE(+)
> In recent versions, the ANSI vesrion (.. .outer join on...) is
> also supported - your version: NULL
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...- Hide quoted text -
>
> - Show quoted text -

apologies for the double post... seems like our IT dept has web caching enabled somewhere.

Thanks for the info! Received on Thu Apr 26 2007 - 20:52:50 CEST