Create View « View « MySQL Tutorial

9.1.Create View
	9.1.1.	A few things aren't allowed in a query that defines a view
	9.1.2.	Creating Views
	9.1.3.	Creating a View with Specified Column Names
	9.1.4.	Creating a View with Joined Tables
	9.1.5.	Adding ORDER BY to the Joined Table View
	9.1.6.	Using a GROUP BY Clause to Create a View
	9.1.7.	Using a GROUP BY Clause to Create a View with ALGORITHM = TEMPTABLE
	9.1.8.	Using HAVING with GROUP BY to Create a View
	9.1.9.	Creating a View with UNION

	9.1.10.	Creating a view by joining two tables