高手帮忙解决下mysql的1248异常

高手帮忙解决下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