If you take a photograph of yourself, and then dye your hair, does the hair colour in the photograph change?
You've effectively taken a snapshot of the data in the 9 tables and placed that in a new table.

If you need the 1 table to always represent the 9 tables, then you have 2 options

• Create a view which spans the 9 tables.  Depending on the size of the tables, you may need a schema-bound view with indexes.
• Create insert, update, delete triggers on the 9 tables which update the new table whenever the data changes.