Home / Q&A / Subqueries cannot be included in a SELECT clause
You can translate the question and the replies:

Subqueries cannot be included in a SELECT clause

Hello, Denodo isn't allowing a subquery to be included in the SELECT clause. Is there any alternative for this? Thanks, Hemant
subquery
user
07-03-2017 08:37:51 -0500

1 Answer

Hi, Denodo does not support sub queries in SELECT clause. I think what you can do is create an Inner Join between both the tables on the fields you have used in your where clause and use GROUP BY to get the similar results. For example : If your desired sub query in select clause is : Select id , date, (Select Count (product) from product where id = s.id ) as product_count from sales s Then you can write the query using JOIN and GROUPBY as Select s.id, date, Count (p.product ) as product_count from sales s INNER JOIN product p on p.id = s.id GROUP BY s.id, date Hope this helps!
Denodo Team
08-03-2017 13:45:30 -0500
You must sign in to add an answer. If you do not have an account, you can register here