Re: Oracle View and Crystal Reports

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...