例如: create materialized view store_amt as select a.store_id, sum(sale_amt) from sales_records a **join salerStore b on a.storeId = b.id** group by a.store_id;