I apologize if I am in the wrong group, but I'm not sure if this deals
more with the Oracle view or how Crystal is using the view I created.
The view script is below:
=============================================
Select
CMDSERIES.ORDR.CUST_CODE,
CMDSERIES.ORDR.CUST_NAME,
CMDSERIES.ORDR.PROJ_CODE,
CMDSERIES.ORDR.PRICE_PLANT_CODE,
CMDSERIES.ORDR.SLSMN_EMPL_CODE,
CMDSERIES.ORDR.ORDER_DATE,
CMDSERIES.ORDR.ORDER_CODE,
CMDSERIES.ORDL.ORDER_DATE,
CMDSERIES.ORDL.ORDER_CODE,
CMDSERIES.ORDL.PROD_CODE,
CMDSERIES.ORDL.PROD_DESCR,
CMDSERIES.ORDL.PRICE_QTY,
CMDSERIES.ORDL.PRICE,
CMDSERIES.PROJ.PROJ_CODE,
CMDSERIES.PROJ.PROJ_NAME,
CMDSERIES.PROJ.CA_SALES_ANL_CODE,
CMDSERIES.EMPL.EMPL_CODE,
CMDSERIES.EMPL.NAME,
CMDSERIES.PLNT.PLANT_CODE,
CMDSERIES.PLNT.NAME
From
CMDSERIES.ORDR,CMDSERIES.ORDL,CMDSERIES.PROJ,CMDSE RIES.EMPL,CMDSERIES.PLNT
WHERE
((CMDSERIES.ORDR.CUST_CODE=CMDSERIES.PROJ.CUST_COD E)
AND(CMDSERIES.ORDR.ORDER_DATE=CMDSERIES.ORDL.ORDER _DATE)
AND(CMDSERIES.ORDR.PROJ_CODE=CMDSERIES.PROJ.PROJ_C ODE)
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_C ODE) 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.

cory.swartz schreef:
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...

On Apr 25, 2:14 pm, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) com>
wrote:
apologies for the double post... seems like our IT dept has web
caching enabled somewhere.

Thanks for the info!