mysql - pentaho数据集成查询sql错误(子查询)

Question

这是我的sql查询

SELECT 
p.Product_Name, d.year4
COUNT (fact_order.sk_product)
FROM 
(SELECT * FROM fact_order limit 0,5000) fo , product p , dim_date d
WHERE fo.sk_product = p.sk_product and fo.sk_order_date = d.date_key and fo.sk_product = ${product_name}
GROUP BY fo.sk_product, d.year4
LIMIT 0,2000 

我希望展示基于产品的年份

Answer 1

尝试

SELECT p.Product_Name, d.year4, COUNT(fo.sk_product)
  FROM (SELECT * FROM fact_order limit 0, 5000) fo, product p, dim_date d
 WHERE fo.sk_product = p.sk_product
   and fo.sk_order_date = d.date_key
   and fo.sk_product = ${product_name}
 GROUP BY fo.sk_product, d.year4,p.Product_Name LIMIT 0, 2000