Subject Re: [firebird-support] Triggers with tow tables
Author Ivan Cruz
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?
>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.