在sql查询分析器里执行这条语句,提示“没有为第3列(属于‘a’)制定列
insert a3 select a.名称,a.编号,isnull(a.数量,0)-isnull(b.数量,0) as 数量 from (select 编号,名称,sum(数量) from a1 group by 编号,名称)a,(select 编号,名称,sum(数量) from a2 group by 编号,名称) b where a.编号 = b.编号
insert a3 select a.名称,a.编号,isnull(a.数量,0)-isnull(b.数量,0) as 数量 from (select 编号,名称,sum(数量) from a1 group by 编号,名称)a,(select 编号,名称,sum(数量) from a2 group by 编号,名称) b where a.编号 = b.编号
,(select 编号,名称,sum(数量) as 数量 from a2 group by 编号,名称) b
select a.名称,a.编号,isnull(a.数量,0)-isnull(b.数量,0) as 数量
from (select 编号,名称,sum(数量) AS 数量 from a1 group by 编号,名称)a,
(select 编号,名称,sum(数量) AS 数量 from a2 group by 编号,名称) b
where a.编号 = b.编号