此主题相关图片如下:错误3.jpg此主题相关图片如下:错误提示2.jpg
SELECT j.Name AS [类型],p.ID AS [编号],p.Name AS [名称],p.Ord AS [排序],p.Mark AS [备注],CASE WHEN p.zt = 1 THEN '启用' ELSE '停用' END AS [状态] FROM dbo.BaseData P JOIN dbo.TpID J ON P.Type = J.ID
zt字段为bit类型