case when ifnull(G.STATE2,'0')='0' and ifnull(H.SUBMIT_TYPE,'1')='1'
then exists(select 1 from t2 where H_ID=G.H_ID)
else '1'
end as iscan
转载于:https://www.cnblogs.com/jcz1206/p/5498870.html
case when ifnull(G.STATE2,'0')='0' and ifnull(H.SUBMIT_TYPE,'1')='1'
then exists(select 1 from t2 where H_ID=G.H_ID)
else '1'
end as iscan
转载于:https://www.cnblogs.com/jcz1206/p/5498870.html