That helps :) You could have two joins to Baby as opposed to the one each one accomplishing a single side in the OR; after which you can use coalesce to get a worth from C or D where You simply want the a person valueIn case you utilize the definition really literally, Of course, but I've always found it reserved for more attention-grabbing sorts o