select dd,aa,bb,cc,[ww]='',[xx]='',[yy]='',[zz]='',[gg]='' from 表1 where dd='ym'
union all
select '','','',ww,xx,yy,zz,gg from 表2 where kk='ym'
union all
select '','','',ww,xx,yy,zz,gg from 表2 where kk='ym'
union all
select kk,'','','',ww,xx,yy,zz,gg from 表2 where kk='ym'
ym y1 y2 y3
ym p1 p2 p3
ym x1 x2 x3 x4 x5
ym m1 m2 m3 m4 m5
=================〉
数据还是列名?