I have to write a query of queries to select aggregates from a query. the query may have spaces in the column names and qoq doesn't seem to like this. How can I do something like the following
using query of queries
I've tried surrounding it in brackets like you do with reserved keywords but it still errors.
Any help would be appreciated. Thanks.
Code:
select sum(col with space)
from qry1
I've tried surrounding it in brackets like you do with reserved keywords but it still errors.
Any help would be appreciated. Thanks.