If you're trying to create a View in your MySQL database and can't, try creating the View via phpMyAdmin.

I have heard of cases where the View could not be create with the SQLyog client, but could be created with phpMyAdmin.