Combining tables

[Arnoldus Th.J. Koeleman]

I have a live feed datasource that inserts into 8 different tables( but
they are all the same layout only differennt regions) and i am not
allowed to change this since it is from a customer.
As with Oracle you can create a materialized view that will combine
those eight tables into one physical table and those will be refreshed
on the fly or on certain times.
Is this also possible in MySQL since we want to query on one table to
find the record instead off eight.