如果指定了 SELECT DISTINCT,那么 ORDER BY 子句中的项就必须出现在选择列表中
去掉distinct有重复值啊,查来查去,不知道怎么办才好,help!
语句如下:
SELECT A.VOUCHER_NO AS [凭证号], CONVERT(VARCHAR(10),A.BOOKKEEPING_DATE,120) AS [记账日期], A.ACCOUNT_YEAR AS [会计年度],
A.ACCOUNT_PERIOD_SEQNO AS [会计期间序号],
A.VOUCHER_TOTAMT AS [金额汇总], A.ACCOUNT_PERIOD_CODE AS [会计期间期号], A.ATTACHMENT AS [附件数],
F.CASHFLOW_ITEM_CODE+F.CASHFLOW_ITEM_NAME AS [现金流量项目],
CASE F.CASHFLOW_ITEM_PROPERTY WHEN '1' THEN '流入 +' WHEN '-1' THEN '流出 -' WHEN '0' THEN '流入 + /流入 -' END AS [性质]
FROM dbo.VOUCHER A JOIN dbo.VOUCHER_D B ON B.VOUCHER_ID = A.VOUCHER_ID
JOIN dbo.ACCOUNT_CODE D ON D.ACCOUNT_CODE_ID = B.ACCOUNT_CODE_ID
JOIN dbo.VOUCHER_SD E ON E.VOUCHER_D_ID = B.VOUCHER_D_ID
JOIN dbo.CASHFLOW_ITEM F ON F.CASHFLOW_ITEM_ID = E.CASHFLOW_ITEM_ID
WHERE A.ApproveStatus = 'Y'
ORDER BY A.BOOKKEEPING_DATE DESC ,A.VOUCHER_NO DESC