I have inherited this (sub) query from a Guy who coveted his work. I have figured out everything else except I cannot figure out what the (+) is for. Because of the field values he could not have been adding the fields.
Does anyone have any idea what (+) means and how it would translate to Access SQL?
Thank you so much,
Trudye
(SELECT 0
FROM SVT_INV_RPT_T
WHERE VIN_NUM=I.VIN_NUM
AND LEASE_ACCT_NUM=I.LEASE_ACCT_NUM
AND BUS_SRC_CD=I.BUS_SRC_CD
AND CUR_RPC_ID IN('S309 ','S308 ')
AND SVT_CATG_TYP_CD='B'
AND VEH_CUR_STAT_CD='AQ')
AND I.MDL_LINE=M.MDL_LINE(+)
AND I.NMC_MDL_CD=M.NMC_MDL_CD(+)
AND I.VIN_YEAR=M.VIN_YEAR(+)
AND I.VIN_NUM=N.VIN_NUM(+)
AND I.VIN_NUM=R.VIN_NUM
AND I.LEASE_ACCT_NUM=R.CNTR_NUM
AND I.BUS_SRC_CD=R.BUS_SRC_CD
AND R.BK_FLG!='Y'
AND I.VEH_SLD_SEQ_NUM=0
Does anyone have any idea what (+) means and how it would translate to Access SQL?
Thank you so much,
Trudye
(SELECT 0
FROM SVT_INV_RPT_T
WHERE VIN_NUM=I.VIN_NUM
AND LEASE_ACCT_NUM=I.LEASE_ACCT_NUM
AND BUS_SRC_CD=I.BUS_SRC_CD
AND CUR_RPC_ID IN('S309 ','S308 ')
AND SVT_CATG_TYP_CD='B'
AND VEH_CUR_STAT_CD='AQ')
AND I.MDL_LINE=M.MDL_LINE(+)
AND I.NMC_MDL_CD=M.NMC_MDL_CD(+)
AND I.VIN_YEAR=M.VIN_YEAR(+)
AND I.VIN_NUM=N.VIN_NUM(+)
AND I.VIN_NUM=R.VIN_NUM
AND I.LEASE_ACCT_NUM=R.CNTR_NUM
AND I.BUS_SRC_CD=R.BUS_SRC_CD
AND R.BK_FLG!='Y'
AND I.VEH_SLD_SEQ_NUM=0