Page Comparison

SELECT UC_LOC_CD, UC_ACCT_NBR, UC_FUND_NBR, FIN_COA_CD, ACCOUNT_NBR
FROM UCI_CA_ACCOUNT_XW_T
WHERE ACTIVE_IND <> 'N' AND
	  ((UC_LOC_CD='9' AND UC_ACCT_NBR='400753' AND UC_FUND_NBR='19933') OR
	  (UC_LOC_CD='9' AND UC_ACCT_NBR='400755' AND UC_FUND_NBR='19900'))
UNION
SELECT DISTINCT ae.UC_LOC_CD, ae.UC_ACCT_NBR'-----', ae.UC_FUND_NBR, ae.FIN_COA_CD, ae.ACCOUNT_NBR
FROM CA_ACCOUNT_T a LEFT OUTER JOIN CA_ACCOUNT_EXT_T ae on
	 (a.ACCOUNT_NBR = ae.ACCOUNT_NBR AND a.FIN_COA_CD = ae.FIN_COA_CD)
WHERE a.ACCT_CLOSED_IND <> 'Y' AND
	  (a.ACCT_EXPIRATION_DT >= getdate() OR a.ACCT_EXPIRATION_DT IS NULL) AND
	  a.ACCT_EFFECT_DT <= GETDATE() AND
	  a.ACCT_TYP_CD = 'CA' AND
	  ((ae.UC_LOC_CD='9' AND ae.UC_FUND_NBR='70003') OR
	  (ae.UC_LOC_CD='9' AND ae.UC_FUND_NBR='70000'))