Page Comparison

SELECT DISTINCT
 UCIa.UC_CA_OBJECT_CODE_XW_TLOC_CD,
 a.UC_ACCT_NBR,
 CONVERT(varchar(4),x.UNIV_FISCAL_YR,) AS UCIUNIV_CA_OBJECT_CODE_XW_TFISCAL_YR,
 x.FIN_COA_CD,
 x.FIN_COAOBJECT_CD,
FROM UC_ACCOUNT_T.UC_ACCT_NBR,
 a
JOIN UCI_CA_OBJECT_CODE_XW_T.FIN_OBJECT x ON a.UC_LOC_CD, = x.UC_ACCOUNT_TLOC_CD
AND a.UC_ACCT_GRP_CD, = UCIx.ACCT_CA_OBJECT_CODE_XW_T.UC_OBJECTGRP_CD
AND a.FIN_COA_CD = x.FIN_COA_CD
FROMWHERE UC_ACCOUNT_T
JOIN UCI_CA_OBJECT_CODE_XW_T
ON UC_ACCOUNT_T(
  (a.UC_LOC_CD = UCI_CA_OBJECT_CODE_XW_T '9' AND a.UC_ACCT_NBR = '100133') OR
  (a.UC_LOC_CD = '9' AND UC_ACCOUNT_Ta.UC_ACCT_GRP_CDNBR = UCI_CA_OBJECT_CODE_XW_T.ACCT_GRP_CD
AND UC_ACCOUNT_T.FIN_COA '101695') OR
  (a.UC_LOC_CD = UCI_CA_OBJECT_CODE_XW_T.FIN_COA_CD
WHERE UC_ACCOUNT_T'9' AND a.UC_ACCT_NBR IN= ('101830101698',)
'268558');