试试这句: select tabel1.分层号, count(table1.分层号) as 数据个数, max(table2.锤击数) as 最大锤击数,min(table2.锤击数) as 最小锤击数,avg(table2.锤击数) as 平均锤击数 from table1,table2 group by 分层号
select tabel1.分层号, count(table1.试验深度) as 数据个数, max(table2.锤击数) as 最大锤击数,min(table2.锤击数) as 最小锤击数,avg(table2.锤击数) as 平均锤击数 from table1,table2 where table1.钻孔号=table2.钻孔号 group by 分层号
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货