34,576
社区成员
发帖
与我相关
我的任务
分享
'aaaa' AS FEENAME
[/quote]'aaaa' AS FEENAME
SELCET
(
CASE
WHEN A.SRC_DOCTYPE = 51 THEN CAST(D.FEENO AS VARCHAR(255))
WHEN A.SRC_DOCTYPE = 53 THEN CAST(E.[NAME] AS VARCHAR(255))
ELSE NULL
END
) AS FEENAME
FROM A \ B \ C \ D \ E五个表
CONVERT(VARCHAR(255),(CASE
WHEN a.SRC_DOCTYPE = 51
THEN D.FEENO
WHEN a.SRC_DOCTYPE = 53
THEN E.NAME
ELSE
NULL
END
)) AS FEENAME