I read manual, it say "not support view".
Any suggestion for better way? thanks
Yes, that's right. MySQL doesn't support views like other RDBMS. You have to execute the entire SQL-Query.
Put it into a String-variable from your program. Or write a userdefined-function which executes your query.
Regards Ingo
