I want to update all rows in tblAAA that satisfy a condition.
A tblAAA has 1 or more tblBBB.
A tblBBB has 1 tblCCC.
I want to update all rows in tblAAA where all of its tblBBB has a tblCCC where tblCCC.status = 1.
Please see provided image.
Really greatful for help, I have been staring at this for two hours but have no clue.