posted 20 years ago
Hi
Are you sure you can run your query sucessfully in sybase? Because I don't see a condition in your query which uniquely identify which row of Tb_A to be updated. If you are using two tables you can do the following in oracle:
If there are three tables involved:
Both queries clearly define which record of Tab1 to be updated. You may change the condition according to your need.
-Sainudheen
[ October 07, 2003: Message edited by: Sainudheen Mydeen ]