Im sure the title of my question is a confusing, but basically I have three columns; all from different subject areas. One is Product name, title name, and Tender name: My boss wants to have a union report and all these items to be under one column titled "description")...
Does anyone have an idea over how to do this??? Somehow, my understanding is for unions to work the columns have to match or have a dummy column for one we need from another subject area.
If not possible, can one "Concatenate" from two separate areas?.. like this: +("Calendar Dates"."Date Calendar Month Abbreviation"||' '||CAST("Calendar Dates"."Date Calendar Year Number" AS CHAR))+