紧急求助：如何把以上命令综合成一个命令？

znyu

1、sql1=select sum(last) from tableA where sore='1' and number='001';
     sql2=select sum(last) from tableA where sore='2' and number='001';

2、insert into tableB (number, sql1, sql2) values ("001", "***", "***";

从表A里面计算出号码为001的类别为1和2的总数，然后插入到表B中。

怎么实现？

同时，001有非常多的记录，如何能避免重复读取“001”？

lybanalysis

Look at this:
/***************************************************/
insert into tableB(number,sql1)values select distinct "001" as number,
select sum(last) as sql1 from tableA where sore='1' and number='001';
insert into tableB(number,sql2) values select distinct "001" as number, select sum(last) as sql2 where sore='2' and number='001";

znyu