Juarez A. Mendes wrote:

>How create a trigger to accumulate the values of the products sell in
>the table SALES_OF_DAY without losing registrations, creating new
>registrations for every new day and in case of altering the data
>there not to be inconsistency of information?
>
>Thanks!
>
>Juarez A. Mendes
>
>
>

Short answer: don't do it. Avoid data duplication at any cost.
GROUP BY is your friend. If performance turns in a issue,
buy hardware. Avoid yourself headaches and hidden costs.

Ivan.