I'm having some problems with the effect of (update..from) query on
tables trigger..
i have two tables ,say A and B, i want to update some of A records
from thier corresponding records at B..
(update A set[...] from B where A.key=B.key)
The problem is that there is an on_UPDATE trigger on A that
inserts a (<old-value,new-value>) record to a LOg table,BUT,
it inserts there an order of 2^n records(!) for n effected records in A.