springMVC下的SQL语句异常：未明确定义的列

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">项目环境为springMVC，在dao中查询数据库事有以下一条sql语句：</span>

<span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre">	</span>SELECT a.ID,a.INSPECT_ID,a.RECTIFIER,a.COPIER,a.NOTIFIER_TYPE, a.CATEGORY,a.PRIORITY,a.STATUS</span><span style="font-family: Arial, Helvetica, sans-serif;">,</span>

<span style="background-color: rgb(255, 255, 255);"></span><pre name="code" class="java" style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Arial, Helvetica, sans-serif;"><span style="color:#ff0000;">b.POST_NAME </span>,<span style="color:#ff0000;">c.POST_NAME</span> ,d.TYPE,e.TYPE_NAME FROM W_INSPECT_NOTIFIER a ,W_POST b,W_POST c,</span>

<span style="font-family: Arial, Helvetica, sans-serif;">W_INSPECT_ITEM d ,W_INSPECT_ITEM_TYPE e WHERE a.STATUS='0' and a.RECTIFIER=b.ID and a.COPIER=c.ID and a.INSPECT_ID=d.ID and d.TYPE=e.ID </span>

<span style="font-family: Arial, Helvetica, sans-serif;"><span style="white-space:pre">	</span>语句本身并没有错误，但是程序运行的时候就会报错：未明确定义的列。</span>

<span style="font-family:Arial, Helvetica, sans-serif;">后来经人指点才知道，虽然sql在plSql中能够正常执行，但是当在hibernate中运行时，是不允许有重名的列存在的。sql中红色的两个字段是同一个表的同一个字段，所以当联合查询组成的新的临时表中这两个字段的名字是一样的，故报错，未明确定义的列。</span>

<span style="font-family:Arial, Helvetica, sans-serif;">修正方法：分别给列起别名</span>

<span style="font-family: Arial, Helvetica, sans-serif;"></span><pre name="code" class="java"><span style="font-family: Arial, Helvetica, sans-serif;"><span>	</span>SELECT a.ID,a.INSPECT_ID,a.RECTIFIER,a.COPIER,a.NOTIFIER_TYPE, a.CATEGORY,a.PRIORITY,a.STATUS</span><span style="font-family: Arial, Helvetica, sans-serif;">,</span>

<span style="background-color: rgb(255, 255, 255);"></span><pre name="code" class="java" style="font-family: Arial, Helvetica, sans-serif;"><span style="color:#ff0000;">b.POST_NAME </span><span style="color:#cc33cc;"> bn</span><span style="color:#ff0000;"> </span>,<span style="color:#ff0000;">c.POST_NAME</span>  <span style="color:#6600cc;">cn </span>,d.TYPE,e.TYPE_NAME FROM W_INSPECT_NOTIFIER a ,W_POST b,W_POST c,

W_INSPECT_ITEM d ,W_INSPECT_ITEM_TYPE e WHERE a.STATUS='0' and a.RECTIFIER=b.ID and a.COPIER=c.ID and a.INSPECT_ID=d.ID and d.TYPE=e.ID 

这样就ok啦。