是行转列吧?
select * from T_HR_SCHMHIS_661459830094394 a
UNPIVOT (
FNUMBER FOR FNAME_L2 IN
( FFSAL207 AS 'FFSAL207',FSAL041 AS 'FSAL041',FSAL007 AS 'FSAL007',FFSAL224 AS 'FFSAL224',FFSAL235 AS 'FFSAL235')
);
没有效果[/quote]
是行转列吧?
select * from T_HR_SCHMHIS_661459830094394 a
UNPIVOT (
FNUMBER FOR FNAME_L2 IN
( FFSAL207 AS 'FFSAL207',FSAL041 AS 'FSAL041',FSAL007 AS 'FSAL007',FFSAL224 AS 'FFSAL224',FFSAL235 AS 'FFSAL235')
);
没有效果[/quote]
而且我这个是要第一个表去关联第二个表的数据,跟行列转换没有关系吧?搞不懂
是行转列吧?
select * from T_HR_SCHMHIS_661459830094394 a
UNPIVOT (
FNUMBER FOR FNAME_L2 IN
( FFSAL207 AS 'FFSAL207',FSAL041 AS 'FSAL041',FSAL007 AS 'FSAL007',FFSAL224 AS 'FFSAL224',FFSAL235 AS 'FFSAL235')
);
没有效果