Got essential to update certain fields of two tables (which got 60+ countless rows) and I am doing the UPDATE inside a loop.

Let me update two tables in one UPDATE (since it's hard to query/traverse two times these tables thinking about the amount of those tables).

I am searching for something similar to these,

UPDATE TABLE_A, TABLE_B

SET TABLE_A.column1 = "new value",
SET TABLE_B.column2 = "different value"

FROM TABLE_A a, TABLE_B b, TABLE_C c
WHERE <few conditions>

Sybase does not appears such as this syntax though. Can there be any options anybody conscious of ?

Thanks ahead of time.

So far as I understand, you are able to define just one table in every UPDATE statement