mybatis中select语句，如果itnlz.TITLE_CNTNT text为空，取出res.test test 怎么写？ 20
selectRESOURCE_ID"id",UP_RESOURCE_ID"upId",RESOURCE_CODE"rescCode",URL,TARGET,ICON,it...
select
RESOURCE_ID "id",
UP_RESOURCE_ID "upId",
RESOURCE_CODE "rescCode",
URL,TARGET,ICON,
itnlz.TITLE_CNTNT text
from t_resource res
left join t_itnlz_text itnlz on res.RESOURCE_ID=itnlz.TITLE_CD1
<include refid="resourceWhere" />
order by res.seq_num 展开
RESOURCE_ID "id",
UP_RESOURCE_ID "upId",
RESOURCE_CODE "rescCode",
URL,TARGET,ICON,
itnlz.TITLE_CNTNT text
from t_resource res
left join t_itnlz_text itnlz on res.RESOURCE_ID=itnlz.TITLE_CD1
<include refid="resourceWhere" />
order by res.seq_num 展开
1个回答
2016-08-01 · 百度知道合伙人官方认证企业
育知同创教育
1【专注：Python+人工智能|Java大数据|HTML5培训】 2【免费提供名师直播课堂、公开课及视频教程】 3【地址：北京市昌平区三旗百汇物美大卖场2层，微信公众号：yuzhitc】
向TA提问
关注
![]()
展开全部
select
RESOURCE_ID "id",
UP_RESOURCE_ID "upId",
RESOURCE_CODE "rescCode",
URL,TARGET,ICON,itnlz.TITLE_CNTNT as TEXT
from t_itnlz_text itnlz
left join t_resource res on res.RESOURCE_ID=itnlz.TITLE_CD1
<include refid="resourceWhere" />
and itnlz.LNG_TP= #{lngTp} and itnlz.title_big_clss= #{titleBigClss}
order by res.seq_num
首先确认下and itnlz.LNG_TP= #{lngTp}前面有空格。
其次，尝试下类似这种写法：<![CDATA[execute_cnt < 6 AND order_way = 35 AND execute_status<>200 ]]>
RESOURCE_ID "id",
UP_RESOURCE_ID "upId",
RESOURCE_CODE "rescCode",
URL,TARGET,ICON,itnlz.TITLE_CNTNT as TEXT
from t_itnlz_text itnlz
left join t_resource res on res.RESOURCE_ID=itnlz.TITLE_CD1
<include refid="resourceWhere" />
and itnlz.LNG_TP= #{lngTp} and itnlz.title_big_clss= #{titleBigClss}
order by res.seq_num
首先确认下and itnlz.LNG_TP= #{lngTp}前面有空格。
其次，尝试下类似这种写法：<![CDATA[execute_cnt < 6 AND order_way = 35 AND execute_status<>200 ]]>
追问
不是我问的问题啊
本回答由网友推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
