select a.yhid,a.zhlx,a.zhzt,a.gsrq,substr(b.jzrq,1,10) as rq,b.jydm,c.jymc
from YKTSZHXY.YKT_ZHXX a
inner join YKTSZHXY.YKT_XFLS b
on a.yhkh=b.xskh
inner join YKTSZHXY.YKT_JYDM c
on b.jydm=c.jydm
where b.jydm in (1110,1721,1722,1170,1120,1780,1760,2270,2271,2296,2297,2298,2262,3263,2310,2314,2315,2311,2312,2313,1261,1140)
group by a.yhid,a.zhlx,a.zhzt,a.gsrq,substr(b.jzrq,1,10),b.jydm,c.jymc
我的数据集如上 
我想要的显示如上
我在每个单元格过滤条件设置
但是显示不出来
|
1min目标场景问卷
立即参与
