SoftTech wrote: << The SQL that follows pulls these results: (These results are missing 5 records from the second select of the union) FEE_CODE AMT_EARNED_AGENCY SHOW_IN_PMT_DIST_PLAN FEE_CATEGORY CCO2 76 1 0 SVC 1.17 1 0 SVC 30 1 0
... ... >> From Helen's Firebird book: If duplicate rows are formed during the creating of the union set, the default behavior is to exclude the duplicate rows from the set. To include the duplicates, use UNION ALL instead of UNION on its own . -- Aage J. [Non-text portions of this message have been removed]