select tpc.cspcode as id ,
tpc.cspcode||'('||tc.cname||'--'|| DECODE(tsp.cpagedesc,'LENGTH(tsp.cpagedesc)>30','...',tsp.cpagedesc)||')' as text
from t_page_channels tpc
inner join t_channels tc
on tpc.ccode = tc.ccode
inner join t_spead_page tsp
on tpc.cpagecode = tsp.cpagecode
where 1 = 1
转载于:https://www.cnblogs.com/Syh0371/p/5806142.html