Can i create view in mysql?

[admin]

I read manual, it say "not support view".

Any suggestion for better way?
thanks