Hi
Can anyone help me amend the code to make the following two joins Left Outer Joins??
CST_COSTCENTRE.CC_LEVELPOINTER = arm_cc_group_names.cc_levelpointer
CST_COSTHEADER.CH_ACCOUNT = SL_ACCOUNTS.CUCODE
Full dump from SQL box below.
Thanks.
SELECT ARM_GP_GROUPINGS.GrpCode, arm_cc_group_names.cc_name, CST_COSTCENTRE.CC_CODE, CST_COSTCENTRE.CC_NAME, CST_COSTCENTRE.CC_LEVELPOINTER, CST_COSTHEADER.CH_CODE, CST_COSTHEADER.CH_NAME, CST_COSTHEADER.CH_USER3, CST_COSTHEADER.CH_USER4, CST_DETAIL.CT_NETT, CST_DETAIL.CT_SORTTYPE, CST_DETAIL.CT_PERIODNUMBR, CST_DETAIL.CT_YEAR, SL_ACCOUNTS.CUCODE, SL_ACCOUNTS.CUNAME
FROM GSLIVE.dbo.arm_cc_group_names arm_cc_group_names, GSLIVE.dbo.ARM_GP_GROUPINGS ARM_GP_GROUPINGS, GSLIVE.dbo.CST_COSTCENTRE CST_COSTCENTRE, GSLIVE.dbo.CST_COSTHEADER CST_COSTHEADER, GSLIVE.dbo.CST_DETAIL CST_DETAIL, GSLIVE.dbo.SL_ACCOUNTS SL_ACCOUNTS
WHERE CST_DETAIL.CT_COSTCENTRE = CST_COSTCENTRE.CC_CODE AND CST_DETAIL.CT_COSTHEADER = CST_COSTCENTRE.CC_COPYHEADER AND CST_COSTCENTRE.CC_COPYHEADER = CST_COSTHEADER.CH_CODE AND CST_COSTCENTRE.CC_LEVELPOINTER = arm_cc_group_names.cc_levelpointer AND CST_COSTHEADER.CH_ACCOUNT = SL_ACCOUNTS.CUCODE AND CST_COSTHEADER.CH_CODE = ARM_GP_GROUPINGS.ch_code AND ((CST_DETAIL.CT_YEAR='C') AND (CST_DETAIL.CT_PERIODNUMBR=1) AND (ARM_GP_GROUPINGS.GrpCode='*') AND (CST_DETAIL.CT_COSTCENTRE Like '4%'))
Can anyone help me amend the code to make the following two joins Left Outer Joins??
CST_COSTCENTRE.CC_LEVELPOINTER = arm_cc_group_names.cc_levelpointer
CST_COSTHEADER.CH_ACCOUNT = SL_ACCOUNTS.CUCODE
Full dump from SQL box below.
Thanks.
SELECT ARM_GP_GROUPINGS.GrpCode, arm_cc_group_names.cc_name, CST_COSTCENTRE.CC_CODE, CST_COSTCENTRE.CC_NAME, CST_COSTCENTRE.CC_LEVELPOINTER, CST_COSTHEADER.CH_CODE, CST_COSTHEADER.CH_NAME, CST_COSTHEADER.CH_USER3, CST_COSTHEADER.CH_USER4, CST_DETAIL.CT_NETT, CST_DETAIL.CT_SORTTYPE, CST_DETAIL.CT_PERIODNUMBR, CST_DETAIL.CT_YEAR, SL_ACCOUNTS.CUCODE, SL_ACCOUNTS.CUNAME
FROM GSLIVE.dbo.arm_cc_group_names arm_cc_group_names, GSLIVE.dbo.ARM_GP_GROUPINGS ARM_GP_GROUPINGS, GSLIVE.dbo.CST_COSTCENTRE CST_COSTCENTRE, GSLIVE.dbo.CST_COSTHEADER CST_COSTHEADER, GSLIVE.dbo.CST_DETAIL CST_DETAIL, GSLIVE.dbo.SL_ACCOUNTS SL_ACCOUNTS
WHERE CST_DETAIL.CT_COSTCENTRE = CST_COSTCENTRE.CC_CODE AND CST_DETAIL.CT_COSTHEADER = CST_COSTCENTRE.CC_COPYHEADER AND CST_COSTCENTRE.CC_COPYHEADER = CST_COSTHEADER.CH_CODE AND CST_COSTCENTRE.CC_LEVELPOINTER = arm_cc_group_names.cc_levelpointer AND CST_COSTHEADER.CH_ACCOUNT = SL_ACCOUNTS.CUCODE AND CST_COSTHEADER.CH_CODE = ARM_GP_GROUPINGS.ch_code AND ((CST_DETAIL.CT_YEAR='C') AND (CST_DETAIL.CT_PERIODNUMBR=1) AND (ARM_GP_GROUPINGS.GrpCode='*') AND (CST_DETAIL.CT_COSTCENTRE Like '4%'))