Re: count items sold between an arrival date and specific days from that arrival date

[Peter Brawley]

Is this what you mean?

select p.item, sum(p.quantity) 
from products p
join arrivals a on a.item=p.item 
                and p.date between a.last_arrival and date_add(a.last_arrival, interval 15 day)
group by p.item;