Using a View to Update the underlying Tables

• The select list can’t include a DISTINCT clause
• The select list can’t include aggregate functions
• The SELECT statement can’t include a GROUP BY or HAVING clause
• The view can’t include the UNION operator

If you want to design views so they can be used to modify data in the tables they are built on, they need to follow the rules for “Updatable Views”, These rules are as follows: