A view definition cannot contain a subquery in the FROM clause of the SQL statement.
User, system, or local variables are not allowed in the SQL SELECT statement.
Views can't point at temporary tables.
Triggers cannot be associated with a view.
Views created within stored procedures can't reference parameters in the stored procedure.
Quote from Pro MySQL
by Michael Kruckenberg (Author), Jay Pipes (Author)
# Paperback: 768 pages
# Publisher: Apress (July 25, 2005)
# Language: English
# ISBN-10: 159059505X
# ISBN-13: 978-1590595053