Question

用sql 实现报表查询

现在有4张表，销售表、进货表、企业支出费用表、其他费用表 ，现在客户要求算出当月每天的利润，
利润=销售额（销售表中）-进货成本（进货表）-支出费用（企业支出费用表）-其他费用（其他费用表），
要显示一个月中每天的利润，求写sql 语句。

Answer 1

select sales.a,sales.b - inbuy.b - cost1.b - cost2.b
from
(select date as a,sum(销售额) as b from 销售表 where date between 开始日期 and 结束日期 group by date ) as sales,
(select date as a,sum(进货额) as b from 进货表 where date between 开始日期 and 结束日期 group by date) as inbuy,
(select date as a,sum(支出额) as b from 企业支出费用表 where date between 开始日期 and 结束日期 group by date) as cost1,
(select date as a,sum(费用额) as b from 其他费用表 where date between 开始日期 and 结束日期 group by date) as cost2
where
sales.a = inbuy.a and
sales.a = cost1.a and
sales.a = cost2.a

Answer 2

SELECT x.riqi,(x.xiaoshoue - j.chengben - z.feiyong - q.qita) AS lirun FROM xiaoshou X,jinhuo j,zhichu z,qita q WHERE x.riqi = j.riqi AND x.riqi = z.riqi AND x.riqi = q.riqi

追问

你的也可以实现，但是分只能给一个，不好意思啊

Answer 3

4张表，销售表、进货表、企业支出费用表、其他费用表 是怎么关联的？用哪个字段？

Answer 4

没有字段怎么写