General information
Category:
Coding, syntax & commands
I am trying to write a select that will give me one record for each sku and a total qty sold. This is what I have so far. My question is where do I put the code to limit the qty sold to a specific date range? I’ve tried adding a where clause, but then I don’t sku’s that don’t have sales history. Any ideas?
select saq_sku, saq_stloc, sum(sal_soldqty);
from scsaqty;
left outer join scsasld;
on saq_stloc == sal_stloc and saq_sku == sal_sku;
where between(sal_solddate,dBgnDate,dEndDate);
group by saq_sku, saq_stloc
Thanks
Pat
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only