求助一SQL语句

有10张表

DATA_101_0507,DATA_102_0507.....DATA_110_0507,

从每个表中按一定规则选出数据,然后插入到a表中

如:

insert into a(name,num)

select name,count(*) from DATA_101_0507

group by name

...

insert into a(name,num)

select name,count(*) from DATA_110_0507

group by name

[244 byte] By [msdn] at [2007-10-1 16:51:04]