|
想问一下,在数据透视集中写SQL语句
SELECT ID, FCLIENTACCOUNT, FBRANCH, FZQ, FRQ,
'短期借款 Short-term loans' AS Item, FA21
FROM dbo.TTL_ZCFZB
UNION
SELECT ID, FCLIENTACCOUNT, FBRANCH, FZQ, FRQ,
'应付票据 Notes payable ' AS Item, FA22
FROM dbo.TTL_ZCFZB
UNION
SELECT ID, FCLIENTACCOUNT, FBRANCH, FZQ, FRQ,
'应付帐款 Accounts payable' AS Item, FA23
FROM dbo.TTL_ZCFZB
UNION
SELECT ID, FCLIENTACCOUNT, FBRANCH, FZQ, FRQ,
'应付工资 Accrued payroll' AS Item, FA24
FROM dbo.TTL_ZCFZB
UNION
SELECT ID, FCLIENTACCOUNT, FBRANCH, FZQ, FRQ, '应交税金 Taxes payable' AS Item,
FA25
FROM dbo.TTL_ZCFZB
是不是不支持的?
那如果我要实现这个功能,然后把fbranch作为列维,item作为行维,怎么实现? |
|