如何使用mysql计算满足两个条件的列的所有值? [英] How to count all values of columns where two conditions are satisfied using mysql?

问题描述

我有两个表，一个是发票"，另一个是invoice_items".所以我想使用这两个表生成报告.

I have two tables one is "invoices" and other is "invoice_items".so i want to generate report using these two tables.

推荐答案

这应该可以解决问题...请查看 CASE WHEN

This should do the trick...please have a look on CASE WHEN

select i.Date, i.No,sum(CASE WHEN t.VAT<>'no'  THEN 
amount ELSE 0 END) as  Excluding_VAT,
sum(t.amt_vat)as vatamount,
sum(CASE WHEN t.VAT='no' THEN amount ELSE 0 END) as  NonVat,
sum(t.amt_vat+t.amount)as totamt
from a i join b t on i.ID=t.ID
where i.Date between '1991-11-18' and '1995-11-19'
group by i.ID,i.No,i.Date

这篇关于如何使用mysql计算满足两个条件的列的所有值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！