Using "AS" for subquery in SAP HANA SQL
I'd want to use "AS" to create a temp table for the result of a subquery. But the query can not be executed.How can I fix this error?
Do I need to create a view ?
c_count, count(*) as custdist
customer left outer join orders on
c_custkey = o_custkey
and o_comment not like '%special%requests%'
)as c_orders (c_custkey,c_count)
Many thanks in advance!
Message was edited by: Tom Flanagan
Please remove "(c_custkey,c_count)" after c_orders.