Is there any way to create a UNION query in the universe?
For example I would like Object X to contain the values from tableA.column1 and tableB.column1.
I had thought that a UNION query would help, but this doesn't seem possible.
I know that it can be done in the report writer, but I would like to shield users from this.
For example I would like Object X to contain the values from tableA.column1 and tableB.column1.
I had thought that a UNION query would help, but this doesn't seem possible.
I know that it can be done in the report writer, but I would like to shield users from this.