I have a report which unions two queries together, but, in the unioned query i have split select statements, with the union done in Cognos SQL.
In another report the union is done at the Native SQL level...
What are the reasons why union could be moved to Cognos SQL