原表SQL命令如下:SELECT U型扣 as 品种, Sum([金额]) AS 汇总FROM U型扣;unionSELECT 电缆 as 品种, Sum([金额]) AS 汇总FROM 电缆;问题:切换为数据表视图后,弹出“输入参数值”,如何把参数值在SQL语句中输入,实现切换为数据表视图后自动成为截图2的效果
ä½ è¯æ³é½æ¯é误çï¼ä½ 表åå«ä»ä¹ï¼fromåè¾¹åºè¯¥æ¯è¡¨åï¼selectååºè¯¥æ¯å段åï¼ä½ä½ ç°å¨åçæ¯å段çå 容ï¼ï¼è¿æï¼union åçè¯å¥åè¾¹ä¸éè¦åå·ãåµä¸è¿ç§ä¸è¥¿ä¹ç¨ä¸çunionæ¥å®ç°ã
综ä¸æè¿°ï¼
select åç§,sum(éé¢) as æ±æ» from 表å where åç§ in ('Uåæ£','çµç¼')表åï¼å段å请ä¸ä¸å¯¹åºã