Re:Transactions

Hi

Lock both tables explicitly first in both transactions in same order 
and then update.

For example

transaction1
commit = false
lock table1
lock table2
update table1
update table2
commit = true


transaction2
commit = false
lock table1
lock table2
update table2
update table1
commit = true


Hope this solves your problem

Sudesh