SELECT *FROM (SELECT a.intID, a.vhrCode AS 编码, a.vhrName AS 名称, a.vhrShortCode AS 简码, a.intProItemType, b.vhrName AS 分类, a.intUnit, c.vhrName AS 单位, a.decCost AS 成本价, a.decOutPrice AS 零售单价, a.intGainType, d.vhrName AS 提成方式, a.decGainValue AS 提成参数, a.bitIsStop, (case when a.bitIsStop=1 then 启用 else 启用) AS 使用状态, a.vhrRe AS 说明, a.intDataType AS 数据类型 FROM (((ProductItem AS a LEFT JOIN BaseData AS b ON a.intProItemType = b.intID) LEFT JOIN BaseData AS c ON a.intUnit = c.intID) LEFT JOIN BaseData AS d ON a.intGainType = d.intID WHERE a.intDataType=0 ORDER BY a.vhrCode)) AS serItem
iif(a.bitIsStop=1,'启用','no启用') AS 使用状态, a.vhrRe AS 说明, a.intDataType AS 数据类型 FROM ((ProductItem AS a LEFT JOIN BaseData AS b ON a.intProItemType = b.intID) LEFT JOIN BaseData AS c ON a.intUnit = c.intID) LEFT JOIN BaseData AS d ON a.intGainType = d.intID WHERE a.intDataType=0 ORDER BY a.vhrCode) AS serItem
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS 使用状态, a.vhrRe AS 说明, a.intDataType AS 数据类型 FROM (((' at line 2
select * from (SELECT a.intID, a.vhrCode AS 编码, a.vhrName AS 名称, a.vhrShortCode AS 简码, a.intProItemType, b.vhrName AS 分类, a.intUnit, c.vhrName AS 单位, a.decCost AS 成本价, a.decOutPrice AS 零售单价, a.intGainType, d.vhrName AS 提成方式, a.decGainValue AS 提成参数, a.bitIsStop,
iif(a.bitIsStop=1,'启用','no启用') AS 使用状态, a.vhrRe AS 说明, a.intDataType AS 数据类型 FROM ((ProductItem AS a LEFT JOIN BaseData AS b ON a.intProItemType = b.intID) LEFT JOIN BaseData AS c ON a.intUnit = c.intID) LEFT JOIN BaseData AS d ON a.intGainType = d.intID WHERE a.intDataType=0 ORDER BY a.vhrCode) AS serItem
iif(a.bitIsStop=1,'启用','no启用') AS 使用状态, a.vhrRe AS 说明, a.intDataType AS 数据类型 FROM ((ProductItem AS a LEFT JOIN BaseData AS b ON a.intProItemType = b.intID) LEFT JOIN BaseData AS c ON a.intUnit = c.intID) LEFT JOIN BaseData AS d ON a.intGainType = d.intID WHERE a.intDataType=0 ORDER BY a.vhrCode) AS serItemor
select * from (
SELECT a.intID, a.vhrCode AS 编码, a.vhrName AS 名称, a.vhrShortCode AS 简码, a.intProItemType, b.vhrName AS 分类, a.intUnit, c.vhrName AS 单位, a.decCost AS 成本价, a.decOutPrice AS 零售单价, a.intGainType, d.vhrName AS 提成方式, a.decGainValue AS 提成参数, a.bitIsStop,
CASE WHEN a.bitIsStop=1 THEN '启用' ELSE 'no启用' END AS 使用状态, a.vhrRe AS 说明, a.intDataType AS 数据类型 FROM ((ProductItem AS a LEFT JOIN BaseData AS b ON a.intProItemType = b.intID) LEFT JOIN BaseData AS c ON a.intUnit = c.intID) LEFT JOIN BaseData AS d ON a.intGainType = d.intID WHERE a.intDataType=0 ORDER BY a.vhrCode) AS serItem