Skip to Content
avatar image
Former Member

union of two queries

For BI custom SQL, hope you can help with what I need to do.

For query 1, I'd like to do select ColA, ColB, " " as ColC from TableA

For query 2, I'd like to do select ColA, ColB, ColC from TableB

The union of these two gives me what I need for my report. This can be easily done in Access. For BI, the " " as ColC is not possible.

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers