Wondering if anyone can help with this issue. I keep getting an oledb read fail from the following. Not a complex query at all and I cannot figure out what could be causing the error. Here is my script:
RA_ADDRESSES_ALL: LOAD ADDRESS_ID2asADDRESS_ID, SITE_NUMBER2asSITE_NUMBER; SELECT/*+RULE */ HCSU.CUST_ACCT_SITE_ID ADDRESS_ID2, HZPS.PARTY_SITE_NUMBER SITE_NUMBER2 FROM HZ_CUST_ACCT_SITES_ALL HCAS, HZ_CUST_SITE_USES_ALL HCSU, HZ_PARTY_SITES HZPS WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID AND HCAS.PARTY_SITE_ID = HZPS.PARTY_SITE_ID AND HCSU.SITE_USE_CODE = 'BILL_TO';