在模糊查询中添加查询语句

select * from humres where station like CONCAT('%',(select o.mstationid from orgunit o inner join humres h on h.orgid=o.id where h.id='297edff87111d03801712b12df610073'),'%') and isdelete=0
posted @ 2022-12-07 15:48  java璀璨小菜鸟  阅读(24)  评论(0)    收藏  举报