摘要: 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 阅读全文
posted @ 2016-05-16 17:32 JIN__JIN 阅读(1519) 评论(0) 推荐(0) 编辑
摘要: http://286.iteye.com/blog/2298505 阅读全文
posted @ 2016-05-16 17:31 JIN__JIN 阅读(1279) 评论(0) 推荐(0) 编辑