hi, i need a report with top ten productos best seller, i have a SQL for this report.
But scriptcase has a conflict with COUNT function, i don not know how can i do it in SC.
This SQL works fine!
select suc_nmbre AS Sucursal, pro_nmbrecrto as Producto, sum(kar_cntdad) as Cantidad
from kar_krdex kar, pro_prdcto pro, suc_scrsal suc
where suc.neg_cdgo = 1
and kar.suc_cdgo = suc.suc_cdgo
and kar.pro_cdgo = pro.pro_cdgo
and kar_fcha > DATE_SUB(CURDATE(),INTERVAL 30 DAY)
group by 1, 2
order by 3 desc limit 10;
How can i do it in SC.
Someone can help me?