Executing these query take: Query returned successfully: 290 rows affected, 2542387 ms execution time. I think that's too many time
I would post the plans that you are getting, otherwise just mentioning the execution time is not very helpful. Also, yet another syntax is the UPDATE foo... FROM tab1, tab2... syntax.