67,512
社区成员
发帖
与我相关
我的任务
分享
select c.aab004,c.acb210 from cb35 c where c.acb330 in
(select t.acb330 from cb33 t where 1=1 and t.acb334 >=
to_date(#{date} , 'yyyy/mm/dd') and t.acb333 <= to_date(#{date}, 'yyyy/mm/dd'))
这个查询出B表字符串id,1,2,3,4,5“”格式。
select c.acb210,c.acb21a,c.acb21r,c.acb300 from Cb21 c where 1=1 and acb210 = #{acb210}
再到B表查询出职业详细