要是我在select后面修改这里的字段就没办法显示后面括号的数值,但一设置括号后面的数组就查不到select DISTINCT [款式表].[类型] || '(' || COUNT([款式表].[类型]) || ')' as 类型与个数
from [产品表] JOIN [款式表] where [产品表].[款式] =[款式表].[ID] group by [款式表].[类型]
不太明白你的意思~下面的视图sql不行吗?
select [款式表].[类型] as 类型, DISTINCT [款式表].[类型] || '(' || COUNT([款式表].[类型]) || ')' as 类型与个数
from [产品表] JOIN [款式表] where [产品表].[款式] =[款式表].[ID] group by [款式表].[类型]