不可以。临时表无法用sql语句访问。
如果你需要用sql语句,可以写 select year(成交日期) as 年, month(成交日期) as 月, 置业顾问, sum(合同值) from {yw_合同值管理} group by year(成交日期) as 年, month(成交日期) as 月, 置业顾问