Copy the :
where SplitEmpID is not null
check into both the inner queries so that it execs before the UNION A-L-L, not after.
If you at all can, change the GROUP BY in the second UNIONed query to be company first, so that it matches the other query and the outer grouping:
group by B.company_name,MediaGroup,companyid,splitempid,issyr, IssMth
) mastertable
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".