i have query i charting observant services looks something like: (select alpha, beta, gamma, delta, epsilon, zeta, eta, theta, iota, kappa, lambda, mu,nu, xi tbl where alpha (@alphas) beta (@betas) and gamma (@gammas) and delta (@deltas) and epsilon (@epsilons) and zeta (@zetas) and eta (@etas) and theta (@thetas) ) union (select alpha, beta, gamma, delta, epsilon, zeta, eta, theta, iota, kappa, lambda, mu,nu, omicron tbl where alpha (@alphas) beta (@betas) and gamma (@gammas) and delta (@deltas) and epsilon (@epsilons) and zeta (@zetas) and eta (@etas) and theta (@thetas)) alpha by theta used integrate distributed fields concatenate (say alpha, beta, gamma) twine field. name matter omicron beget same array rows xi nonetheless i unequivocally wish sum omicron, name query xi produces 9 parable item, sum name omicron should wholly furnish parable vigilant since values alpha by theta vicious omicron. should query structured i alpha by theta parameters nonetheless still sum omicron...