I am trying to join our sales analysis file, all fields, with our accounts receivable file using SQL. I can extract the information okay but when I issue the following fetch command:
FETCH NEXT FROM SALESSORT
INTO :SALESREC ,:CUSTREC
it skips the null records. I have spent the last 6 hours researching this problem with no success. Is there any way to read in the null records? Right now we are using to many work files to do this kind of project and I am trying to change that. Any help will greatly be appreciated.