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 优化
最新推荐文章于 2024-04-21 22:59:02 发布
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')||',%' ;