ttsbegin; while select forupdate firstTable join secondTable where secondTable.ItemId == firstTable.ItemId { secondTable.field_1 = 1; secondTable.field_2 = 2; secondTable.update(); } ttscommit;