我有关于学校田径的信息,包括学校,季节,现金流量和cashflow_group的表格.我正在尝试在用户指定的范围内查询所有现金流在一个或多个给定的cashflow_groups中的学校.我需要在同一查询中查询多个不同的类别.我有麻烦了
我的查询如下.之所以这样做,是因为我可以汇总多个现金流量组,并且我认为它一直有效,直到我仔细观察并看到,它将所有学校的现金流量总和作为total_cashflow_amount,当每所学校应该有不同的总计时,总和其相关的现金流量行.
SELECT distinct schools.*,
(SELECT sum(`cashflows`.amount) AS cf FROM `schools`
INNER JOIN `seasons` ON seasons.school_id = schools.id
INNER JOIN `cashflows` ON cashflows.season_id = seasons.id
INNER JOIN `cashflow_groups` ON `cashflow_groups`.id = `cashflows`.cashflow_group_id
WHERE ((`cashflow_groups`.id = 12) AND (`seasons`.`year` = 2010))) AS total_branding_cashflow
FROM `schools`
INNER JOIN `seasons` ON seasons.school_id = schools.id
INNER JOIN `cashflows` ON cashflows.season_id = seasons.id