目前用的SQL代码:
SELECT DISTINCTROW tbAssign.ClientAssNo, tbAssign.BudgetHours, Sum(tbVisit.Hours) AS [Hours 之 总计]
FROM tbAssign INNER JOIN tbVisit ON tbAssign.[IDA] = tbVisit.[IDA]
GROUP BY tbAssign.ClientAssNo, tbAssign.BudgetHours;
其中tbAssign为主表,tbVisit为子表,以IDA关联
现在的问题是,在查询tbAssign时,我想汇总tbVisit的Hours
按上面的代码可以得出汇总结果,但是如果tbAssign的IDA下没有输入过tbVisit数据,就不显示出来了
也就是说,这个查询只能汇总查询有过tbVisit记录的tbAssign
有没有办法让这个查询显示每条tbAssign记录,即使tbVisit数据为空?
SELECT DISTINCTROW tbAssign.ClientAssNo, tbAssign.BudgetHours, Sum(tbVisit.Hours) AS [Hours 之 总计]
FROM tbAssign left JOIN tbVisit ON tbAssign.[IDA] = tbVisit.[IDA]
GROUP BY tbAssign.ClientAssNo, tbAssign.BudgetHours;