select *,'AA' 第一列,'BB' 第二列,'CC' 第三列 from ( select fieldname as col1 from tablename where fieldname like 'A%' ) as a,( select fieldname as col2 from tablename where fieldname like 'B%' ) as b,( select fieldname as col3 from tablename where fieldname like 'C%' ) as c,( select fieldname as col4 from tablename where fieldname like 'D%' ) as d这样?
from (
select fieldname as col1 from tablename where fieldname like 'A%'
) as a,(
select fieldname as col2 from tablename where fieldname like 'B%'
) as b,(
select fieldname as col3 from tablename where fieldname like 'C%'
) as c,(
select fieldname as col4 from tablename where fieldname like 'D%'
) as d这样?