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