Re: (+) in SQL

It denotes an OUTER JOIN. Try:

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/expressi.htm#1023213

hth

Bricklen

judy wrote:
>
> Please help!What does the (+) means in the where clause?
>
> Select distinct(T.Timesht_id),
> T.FISC_PY_PRD_NBR,
> T.PAYR_WK_NBR,
> T.WK_END_DT,
> T.EMP_APRV_IND,
> T.MAINFRM_UPLD_DT,
> T.Govt_FISC_YR,
> T.Supv_Aprv_Ind,
> E.FMIS_ORG_NBR,
> E.Emp_lst_nm,
> E.SUPV_IND,
> E.Emp_FRST_NM,
> E.FMIS_EMP_ID,
> E.SUPV_ID,
> E.Emp_email
> From ITA.TPLAN_EMP E, ITA.TEMP_TIMESHT T, ITA.TDLY_HR H, ITA.TCMPNS_REQ TC
> Where E.FMIS_EMP_ID = T.FMIS_EMP_ID
> AND T.Timesht_id = H.Timesht_id
> AND FMIS_DEPT_NBR = '#client.FMIS_DEPT_NBR#'
> AND H.TIMESHT_ID = TC.TIMESHT_ID (+)
> AND H.SEQ_NBR = TC.SEQ_NBR (+)
>
> #preservesinglequotes(attributes.GetAllTimeSheetsWhereClause)#
> Order by to_number(T.GOVT_FISC_YR) DESC,
> TO_NUMBER(T.FISC_PY_PRD_NBR) DESC,
> TO_NUMBER(T.PAYR_WK_NBR) DESC,
> E.FMIS_ORG_NBR,
> E.Emp_lst_nm
Received on Tue Jul 02 2002 - 20:34:02 CEST