Sorry for the delay. I set the 'Preserve Colunm Sort/Filter/Layout' to false and there was no change in the result. It still dropped data. This is the SQL.
SELECT fund.taxdist, fund.county, bud.fund, bud.cc, bud.revexp, bud.occ, bud.oproj, bud.supcode, bud.acct, objcatstcls.objname...