You can create a trigger on Table A and update the Table B directly, why to create Table C just for later joining it with TableB.