Select a.检测号,AVG(a.纵向CV值)AS 平均CV值,AVG(a.平均值)AS平均灰度值,
b.批号 as 批号, b.色号 as 色号, b.横向CV as 横向CV
from ParaCol a,Test b where a.检测号 = b.检测号
Group by a.检测号, b.批号, b.色号, b.横向CV
Order By 检测号
b.批号 as 批号, b.色号 as 色号, b.横向CV as 横向CV
from ParaCol a,Test b where a.检测号 = b.检测号
Group by a.检测号, b.批号, b.色号, b.横向CV
Order By 检测号
b.批号 as 批号, b.色号 as 色号
from ParaCol a,Test b where a.检测号 = b.检测号
Group by a.检测号,b.检测号,b.批号, b.色号, b.横向CV
Order By 检测号
from ParaCo1
Group by 检测号 Order By 检测号
UNION ALL
select 横向CV,批号,色号 from test
order by 检测号
Group by 检测号 Order By 检测号
UNION ALL
select 横向CV,批号,色号 from test
order by 检测号
(Select DISTINCT 检测号,AVG(纵向CV值)AS 平均CV值,AVG(平均值)AS 平均灰度值 from ParaCo1
Group by 检测号) B on A.检测号=B.检测号