Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle View and Crystal Reports

Re: Oracle View and Crystal Reports

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 25 Apr 2007 20:14:56 +0200
Message-ID: <f0o5li$bi2$1@news5.zwoll1.ov.home.nl>


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...
Received on Wed Apr 25 2007 - 13:14:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US