sql kinship an public component

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?