General information
Category:
Coding, syntax & commands
I updated the select to include the file names. SCSAQTY is a table that contains sku# and pricing. SCSASLD contains sold history. A sku can be in the sold file many times.
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 scsaqty.saq_sku, scsaqty.saq_stloc, sum(scsasld.sal_soldqty);
from scsaqty;
left outer join scsasld;
on scsaqty.saq_stloc == scsasld.sal_stloc and scsaqty.saq_sku == scsasld.sal_sku;
where between(scsasld.sal_solddate,dBgnDate,dEndDate);
group by scsaqty.saq_sku, scsaqty.saq_stloc
Previous
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