我需要一个表的总和与另一个表和独显的总和，当一个比另一个

Question

这里更大的是我的代码

select sum(IV.total) as total, 
     IV.sono, 
     sum(SO.total) as total2 
    from tblInvoiceDetail as IV 
     left join tblSO as SO on IV.sono=SO.sono 
where IV.sono not in (108428,108368) 
group by IV.sono 
having sum(SO.total) < sum(IV.total) 
order by IV.sono DESC 

Answer 1

您可以使用子查询这样做：

select IV.sono, ivtotal, sototal 
    from (select sono, sum(total) ivtotal from tblInvoiceDetail group by sono) as IV 
     LEFT JOIN 
     (select sono, sum(total) sototal from tblSO group by sono) as SO 
     ON IV.sono = SO.sono 
where SO.sototal < IV.ivtotal 
    and IV.sono not in (108428,108368) 
order by IV.sono DESC