I have 12 queries with 4 same fields 1 different field in each query. Like this:
(1) -districtID, FacilityID, AssessmentAreaID, AssessmentTypeID, TotalANCStds
(2) -districtID, FacilityID, AssessmentAreaID, AssessmentTypeID, TotalNLDStds
How do i create my union query to come up with one query with all total fields included?