Category "criteria"

Entire Union query returns no results if part of it returns no results

I've created the folllowing Union query, which works fine most of the time: SELECT [%$##@_Alias].[Contact ID], [%$##@_Alias].[Mailing Name] FROM (SELECT [Refer