Hello,
I would like to synchronize 2 tables.
I think that maybe triggers are the best solution.
But, if i create two update trigger, when i update the first table first
trigger update the other, and the other trigger also try to update the
first table... and this is an infinite loop.
At now, in all two triggers i first drop the other and after the update
recreate.
I think that this is not the _best_ solution.
Can you show me a better solution?
thanks.
PS:
please CC: for my personal e-mail address, I'm not subscribed.
Veres Lajos
vlajos@ludens.elte.hu
+36 20 438 5909