lanky_doodle - Wednesday, February 28, 2018 10:13 AM
The SELECT clause is evaluated AFTER the WHERE clause, so using literal values in the SELECT clause cannot possibly have any effect on the number of records returned. Specifically, it cannot cause records to return in place of an empty set. You need to look elsewhere to determine why those values are showing up in your results. I would start by running each of your UNIONed sets separately.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA