Thanks for all the responses.  I'll try to run full execution plans this weekend for the query using the COALESCE JOIN and the previous.  I'm a pretty competent coder, I...