这样可不可以?
select * from (select 源地址,SUM(单价) AS 金额
FROM TEMP_INFO
GROUP BY 源地址)as a ,(SELECT 源地址, COUNT(DISTINCT 电报编码) AS 发电地址数
FROM tel_info_view
GROUP BY 源地址
ORDER BY 源地址) as b
where a.字段=b.字段
select * from (select 源地址,SUM(单价) AS 金额
FROM TEMP_INFO
GROUP BY 源地址)as a ,(SELECT 源地址, COUNT(DISTINCT 电报编码) AS 发电地址数
FROM tel_info_view
GROUP BY 源地址
ORDER BY 源地址) as b
where a.字段=b.字段
(select distinct 电报编码,源地址,单价 from tel_info_view)
a, tel_info_view b where a.a.源地址=b.源地址 GROUP BY a.源地址
FROM (SELECT a.源地址, SUM(a.单价) AS 金额
FROM (SELECT DISTINCT 电报编码, 源地址, 单价
FROM tel_info_view) a
GROUP BY a.源地址) a INNER JOIN
(SELECT 源地址, COUNT(DISTINCT 电报编码) AS 发电地址数
FROM tel_info_view
GROUP BY 源地址) b ON a.源地址 = b.源地址
ORDER BY a.源地址