That is interesting and thanks for sharing. This is equivalent to the UNION ALL operator but not the UNION operator. I suppose that you can take the query, wrap it and then select distinct * from it. I wonder how that would compare to the UNION (for I try to avoid distinct * ).