select a.area_id,a.area_name,a.depth,a.up_area from table1 a
where a.area_ids LIKE '%,'||(select a.dept_id from table2 a where login_name='xiajianyi')||',%' ;
start with 优化
最新推荐文章于 2022-05-23 17:25:43 发布
select a.area_id,a.area_name,a.depth,a.up_area from table1 a
where a.area_ids LIKE '%,'||(select a.dept_id from table2 a where login_name='xiajianyi')||',%' ;