When I insert a record into table A, it doesnt update table B that has been derived from Table A. I have used a where clause as I only want certain records from Table A in my Table B. This is my code 

CREATE TABLE B AS (
SELECT \* FROM A
WHERE STATUS='STUDENT'
);

When inserting a new record into table A with the new attribute "student" it doesnt update table B. Thank you!