access数据库,我想把联合查询的结果用insert into 追加到一个表中,这样可以吗?有语句
insert into 总计价 e (e.编码,e.名称,e.综合单价,e.取费信息) //这是实际的表
select
(
select a.编码,a.名称,sum(iif (a.信息价>0 ,a.信息价*a.实际量 * b.工程量,a.基价*a.实际量 * b.工程量)) as 总价,b.专业取费 from(select * from 分项材料明细) as a,[select 专业取费,编号,工程量 from 分项]. AS b where (((a.供应方)='乙供暂估')) OR (((a.供应方)='甲供暂估') AND ((a.换算)<>'定' Or (a.换算) is null ) AND ((a.主表编号)=[b].[编号]))
GROUP BY a.编码, a.名称,b.专业取费
union all
select c.编码,c.名称,sum(iif (c.信息价>0 ,c.信息价*c.实际量 * d.工程量,c.基价*c.实际量 * d.工程量)) as 总价 ,d.专业取费 from(select * from 技术材料明细) as c,[select 专业取费,编号,工程量 from 技术]. AS d where (((c.供应方)='乙供暂估')) OR (((c.供应方)='甲供暂估') AND ((c.换算)<>'定' Or (c.换算) is null ) AND ((c.主表编号)=[d].[编号]))
GROUP BY c.编码, c.名称,d.专业取费
) from //后面这里不知怎么写了