如果你的W表是主表:select w.start_3 as perpare_field, w.fact_money+isnull(sum(t.amount),0) as amount from wood_info w join traffic_wood_info T on T.operation_no=w.operation_no where (w.oper_date>='2004-9-29 0:00:01') and (w.oper_date<='2004-9-29 23:59:59') group by w.start_3,w.fact_money order by w.amount desc否则的话,反过来sum(w表的数量)+t.amount
select w.start_3 as perpare_field, sum(w.fact_money) as fact_money, sum(traffic_wood_info.amount) as amount1, from wood_info w LEFT OUTER JOIN traffic_wood_info on traffic_wood_info.operation_no=w.operation_no where (w.oper_date>='2004-9-29 0:00:01') and (w.oper_date<='2004-9-29 23:59:59') group by w.start_3 order by w.amount1 desc
select w.start_3 as perpare_field, sum(w.fact_money) as fact_money, sum(traffic_wood_info.amount) as amount1 from( select operation_no,start_3,sum(fact_money) as fact_money from wood_info where oper_date>='2004-9-29 0:00:01' and oper_date<='2004-9-29 23:59:59' group by operation_no,start_3 )w join traffic_wood_info on traffic_wood_info.operation_no=w.operation_no group by w.start_3 order by w.amount1 desc
operation_no 应该是wood_info的主键才可以做 select a.start_3,sum(a.fact_money) as fact_money,sum(b.amount) as amount1 from ( select operation_no,start_3,fact_money from wood_info where (w.oper_date>='2004-9-29 0:00:01') and (w.oper_date<='2004-9-29 23:59:59') ) a left join ( select operation_no,sum(amount) as amount1 from traffic_wood_info group by operation_no) b on a.operation_no=b.operation_no
w.fact_money+isnull(sum(t.amount),0) as amount
from wood_info w join traffic_wood_info T on T.operation_no=w.operation_no
where (w.oper_date>='2004-9-29 0:00:01') and (w.oper_date<='2004-9-29 23:59:59')
group by w.start_3,w.fact_money
order by w.amount desc否则的话,反过来sum(w表的数量)+t.amount
sum(w.fact_money) as fact_money,
sum(traffic_wood_info.amount) as amount1,
from wood_info w LEFT OUTER JOIN traffic_wood_info on traffic_wood_info.operation_no=w.operation_no
where (w.oper_date>='2004-9-29 0:00:01') and (w.oper_date<='2004-9-29 23:59:59')
group by w.start_3 order by w.amount1 desc
sum(w.fact_money) as fact_money,
sum(traffic_wood_info.amount) as amount1
from(
select operation_no,start_3,sum(fact_money) as fact_money
from wood_info
where oper_date>='2004-9-29 0:00:01' and oper_date<='2004-9-29 23:59:59'
group by operation_no,start_3
)w join traffic_wood_info on traffic_wood_info.operation_no=w.operation_no
group by w.start_3 order by w.amount1 desc
select a.start_3,sum(a.fact_money) as fact_money,sum(b.amount) as amount1
from (
select operation_no,start_3,fact_money from wood_info
where (w.oper_date>='2004-9-29 0:00:01') and (w.oper_date<='2004-9-29 23:59:59') ) a
left join (
select operation_no,sum(amount) as amount1 from traffic_wood_info group by operation_no) b
on a.operation_no=b.operation_no