高手帮忙解决下mysql的1248错误
我将oracle项目的数据库转换为mysql,部署之后执行任何SQL语句好象都会出现错误
2007-09-13   09:24:47,015   [org.hibernate.util.JDBCExceptionReporter]-[ERROR]   Every   derived   table   must   have   its   own   alias
  2007-09-13   09:24:47,015   [ERROR]   org.hibernate.exception.SQLGrammarException:   could   not   execute   query

以下是我查找的mysql信息
Error:   1248   SQLSTATE:   42000   (ER_DERIVED_MUST_HAVE_ALIAS)  

Message:   Every   derived   table   must   have   its   own   alias


------解决方案--------------------
Message: Every derived table must have its own alias

很明显了。
每个表必须有自己的别名
------解决方案--------------------
()括号之后加个 AS a