有where 没 from？

看不懂

---------

WITH A AS (

SELECT Area,

COUNT(1) AS Status

FROM sss

GROUP BY Area

UNION

SELECT Area,

COUNT(1) AS Status

FROM sss1

GROUP BY Area

UNION

SELECT Area,COUNT(1) AS Status

FROM sss2

GROUP BY Area

)

select * from (

SELECT A.AREA,'年' AS Time_dimension,SUM(A.Status) Status

FROM A

WHERE YEAR(A.Date)=YEAR(GETDATE())

GROUP BY A.AREA

UNION

SELECT A.AREA,'月' AS Time_dimension,SUM(A.Status) Status

FROM A

WHERE MONTH(A.DATE) =MONTH(GETDATE())

GROUP BY A.AREA

) t where 1=1 ${if(len(控件名)==0,"",IF(控件名=="年"," and t.Time_dimension='年'"," and t.Time_dimension='月'")}

你的A.date没有这个字段啊，需要给Time_dimension参数那就在包一层就好了

-------------------------------------------------------------------------------------------------------------

WITH A AS (

SELECT Area,

COUNT(1) AS Status

FROM sss

GROUP BY Area

UNION

SELECT Area,

COUNT(1) AS Status

FROM sss1

GROUP BY Area

UNION

SELECT Area,COUNT(1) AS Status

FROM sss2

GROUP BY Area

),

B AS (

SELECT A.AREA,'年' AS Time_dimension,SUM(A.Status) Status

FROM A

WHERE YEAR(A.Date)=YEAR(GETDATE())

GROUP BY A.AREA

UNION

SELECT A.AREA,'月' AS Time_dimension,SUM(A.Status) Status

FROM A

WHERE MONTH(A.DATE) =MONTH(GETDATE())

GROUP BY A.AREA

)

SELECT * FROM B WHERE  Time_dimension = '${Time_dimension}'