union of two queries

[Former Member]

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.

[chris_keating]

Try single quotes for Query 1 as in: select ColA, ColB, ' ' as ColC from TableA. The double quotes tend to be used for identifiers.