That helps :) You could have two joins to Kid as opposed to the one every one executing one facet in the OR; and afterwards use coalesce to acquire a benefit from C or D where You merely want the one particular valueThis is where an Use is available in useful as you can use it without needing to duplicate your entire outer query, as it has use of t