目前的结果如图显示
我要显示成这样的
2行合并成一行 貌似不需要分组 不用 wm concat 这个函数(记不清了)
我的sql 如下:
select t.displayname||':' || h.parametervalue as 折扣
from his_productordericb h
left join ICBPATTERNPARAMETER t
on h.icbpatternparameterid=t.icbpatternparameterid
where h.productorderratepolicyid in
(select n.productorderratepolicyid new_id
from (select
b.productorderid,
a.rateplanid,
c.description
from ProductSpecRatePlanAssoc a
left join his_productorder b
on b.productspecid = a.productspecid
left join rateplan c
on a.rateplanid = c.rateplanid
where a.productspecid = b.productspecid
and a.rateplanid = c.rateplanid
and c.rateplanid in (525,
526,
527,
528,
529,
530,
531,
532,
991,
992,
993,
994,
995,
996,
997,
998)
and b.productorderid = '8684231') m
left join his_productorderratepolicy n
on m.rateplanid = n.rateplanid
and m.productorderid = n.productorderid
and n.action = 1)
谢谢大家