Please help me with the following
Table 'A' has three dependent tables namely 'B','C' AND 'D' related by col1.
Tables B,C have their own composite primary keys which includes col1 as one of their key and also B is the parent composite primary key for C table composite primary/reference key.
Now I want to change a non key value(col10) in table B for a parent row which has 1200 child rows in table C.
Please help me how to change the value of the non key col10 in table B(1 row) and C(1200 rows).Cascade update cannot be done because col10 is not a part of the key and also I want to keep the col1 value the same.
thanks in advance
Click Here to Expand Forum to Full Width