what is the difference of static view and dynamic view?
Dynamic views can contain data from one or two tables and automatically include all of the columns from the specified table or tables. ... Static views can contain data from multiple tables and the required columns from these tables must be specified in the SELECT and WHERE clauses of the static view.