On Mon, Nov 12, 2001 at 11:14:21AM -0500, Johnson, Gregert wrote:
% SELECT SUM(d.AcctSessionTime) + IFNULL(m.Minutes, 0)
% FROM detail d LEFT OUTER JOIN monthly_usage m ON d.UserName = m.UserName
% WHERE d.UserName = 'foo';
%
% Or, to summarize for all users:
%
% SELECT d.UserName as user, SUM(d
SELECT SUM(d.AcctSessionTime) + IFNULL(m.Minutes, 0)
FROM detail d LEFT OUTER JOIN monthly_usage m ON d.UserName = m.UserName
WHERE d.UserName = 'foo';
Or, to summarize for all users:
SELECT d.UserName as user, SUM(d.AcctSessionTime) + IFNULL(m.Minutes, 0)
FROM detail d LEFT OUTER JOIN monthly_u
