Again, a helpful response. Thanks.

I was a UNIX/Informix DBA through the 1990's. My only work with SQL Server had been data transfer but now that I'm working with...

Thanks, Evil Kraig. Your answer makes perfect sense for the larger SQL, which actually 'UNIONs' 3 queries use multipple table-joins, MAX(), placeholder columns and all sorts of complications....