select name from A where code like (select code from B where orgid ='1')||'%'
ORACLE的like后面跟一个子查询
最新推荐文章于 2023-09-13 00:38:09 发布
select name from A where code like (select code from B where orgid ='1')||'%'