<select id="querysegmentedTotalStatistics" parameterType="com.hp.operationService.messageexchange.pojo.SmsGatewayStatisticsPojo" resultType="com.hp.operationService.messageexchange.pojo.SmsGatewayStatisticsPojo">
select orgid,
(select orgname from organize b where a.orgid = b.orgid) orgname,
count(*)
<if test="relatedownsmstable!= null and relatedownsmstable!=''">
from ${ relatedownsmstable} a
</if>
group by orgid
union all
select orgid,(select orgname from organize b where a.orgid = b.orgid) orgname,count(*)
<if test="relatedownsmstable!= null and relatedownsmstable!=''">
from ${ relatedownsmstable} a
</if>
group by orgid
union all
select orgid,(select orgname from organize b where a.orgid = b.orgid) orgname,count(*)
<if test="relatedownsmstable!= null and relatedownsmstable!=''">
from ${relatedownsmstable} a
</if>
group by orgid
union all
select orgid,(select orgname from organize b where a.orgid = b.orgid) orgname,count(*)
<if test="relatedownsmstable!= null and relatedownsmstable!=''">
from ${ } a
</if>
group by orgid
</select>
請問我這樣寫為什么報這個錯誤?在線等大神解答
uj5u.com熱心網友回復：
select orgid,(select orgname from organize b where a.orgid = b.orgid) orgname,count(*)<if test="relatedownsmstable!= null and relatedownsmstable!=''">
from ${ } a
</if>
uj5u.com熱心網友回復：
請問占位符里邊不謝變數名嗎?大神uj5u.com熱心網友回復：
你怎么沒寫變數名（表名）呢？
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/99312.html
標籤：開發
上一篇：oracle大神請進
下一篇：oracle 行程被kill