考虑要更新的列更新多个表位于“where”

There are 3 tables - 1 parent and 2 child (child PK has FK to parent PK) I need to update some columns in all 3 tables with one 'where' depends on updating columns. So, it will be 3 update statements in one transaction, but the first update changes columns and 'where' become tampering (for the last two updates). Is there common way to solve this problem?There are 3 tables - 1 parent and 2 child (chil