select 材料编号 as 编号 , sum(数量) as 数量 from
(
SELECT
a.材料编号,
sum(a.数量*b.数量) as 数量
FROM
表A a,
表B b
WHERE
a.类型=b.类型
GROUP BY
a.材料编号
) t
group by 材料编号
(
SELECT
a.材料编号,
sum(a.数量*b.数量) as 数量
FROM
表A a,
表B b
WHERE
a.类型=b.类型
GROUP BY
a.材料编号
) t
group by 材料编号
(
SELECT
a.材料编号,
sum(a.数量*b.数量) as 数量
FROM
表A a,
表B b
WHERE
a.类型=b.类型
GROUP BY
a.材料编号
) t
group by 材料编号
);if (clk1->IsOpen()) clk1->Close();
clk1->Open(CRecordset::snapshot,SQLOpen2);这样行么?在VC中却通不过好像。提示“无法描述的索引”