each is based on a multitable select statement that includes an expression and a literal value in the column list 每種方法都基于一個多表select語句,該語句在列列表中包含一個表達式及一個文字值。
in an indexed view definition, the select statement must be a single table statement or a multitable join with optional aggregation 在索引視圖定義中,select語句必須是單個表的語句或帶有可選聚合的多表join。
must be updatable and reference exactly one base table in the from clause of the view . for example, an insert into a multitable view must use a 引用的視圖必須可更新,并且只在該視圖的from子句中引用一個基表。