Hi Naomi and Borislav
Sorry, I´ll try to be more clear.
The dates comes from another table. Products are put on sales in different times during the day. For every producT I need to calculate the total sales from the entire store after that time.
Product A - Start Sales at 2009-02-26 08:00AM ->Total sales from the store after 2009-02-26 08:00AM till now- 600000
Product B - Start Sales at 2009-02-25 10:00AM ->Total sales from the store after 2009-02-25 10:00 AM till now 900000
Table A stores these dates of beggining sales and Table B stores individual sales I need a sum of sales for each start sales