That helps :) You could have two joins to Child in lieu of the a single each one performing a single facet from the OR; and then use coalesce to get a benefit from C or D where You simply want the a single benefit To accept as a pacesetter https://sparkyt319zbc0.techionblog.com/profile