with user表 as
(select '小三' 姓名, 'A1B1' 准假车型
FROM DUAL
UNION ALLSELECT '土豪', 'A1C'
from dual
union allSELECT '屌丝', 'B1D'
from dual
union allSELECT '高富帅', 'CD'
from dual),
INFORMATION AS
(SELECT 'A1' 准驾车型, '小车' 车型名字
from dual
union allSELECT 'B1', '中车'
FROM DUAL
UNION ALLSELECT 'C', '大车'
FROM DUAL
UNION ALLSELECT 'D', '拖拉机'
FROM DUAL)
select 姓名, wmsys.wm_concat(车型名字)
from user表 t, information k
where t.准假车型 like '%' || k.准驾车型 || '%'
group by 姓名那个帖子都写过了,就不用再发了吧。。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货