Skip to Content
0

union of two queries

Feb 09, 2017 at 01:56 AM

36

avatar image
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.

SQL
10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers