select c.total_amount as amount1 ,sum(spp.total_amount) as amount2 from contract c,sales_process sp,sales_process_product spp
where c.contract_id=sp.contact_id and sp.sales_process_id=spp.sales_process_id
group by c.contract_id,c.total_amount
where c.contract_id=sp.contact_id and sp.sales_process_id=spp.sales_process_id
group by c.contract_id,c.total_amount
select c.total_amount as amount1 ,
sum(spp.total_amount) as amount2
from contract c,sales_process sp,sales_process_product spp
where c.contract_id=sp.contact_id
and sp.sales_process_id=spp.sales_process_id
group by c.contract_id, c.total_amount
我觉得只要把c.contract_id 改成c.total_amount 就行了
1.
select c.total_amount as amount1 ,
sum(spp.total_amount) as amount2
from contract c,sales_process sp,sales_process_product spp
where c.contract_id=sp.contact_id
and sp.sales_process_id=spp.sales_process_id
group by c.contract_id, c.total_amount
2.
select c.total_amount as amount1 ,
sum(spp.total_amount) as amount2
from contract c,sales_process sp,sales_process_product spp
where c.contract_id=sp.contact_id
and sp.sales_process_id=spp.sales_process_id
group by c.total_amount
3.
select c.contract_id,c.total_amount as amount1 ,
sum(spp.total_amount) as amount2
from contract c,sales_process sp,sales_process_product spp
where c.contract_id=sp.contact_id
and sp.sales_process_id=spp.sales_process_id
group by c.contract_id, c.total_amount
4.
select c.contract_id as amount1 ,
sum(spp.total_amount) as amount2
from contract c,sales_process sp,sales_process_product spp
where c.contract_id=sp.contact_id
and sp.sales_process_id=spp.sales_process_id
group by c.contract_id
就看你具体情况而定了