Re: "Sum distinct"

Here's one method. SQL92 except for the reserved word "value" but tested on SQL Server 2000.

SELECT M.manager, M.salary, S.value
 FROM
(SELECT manager, SUM(salary) AS salary

  FROM salesman
  GROUP BY manager) AS M,
(SELECT manager, SUM(value) AS value

  FROM salesman, sale
  WHERE salesman.id = sale.salesman_id
  GROUP BY manager) AS S
 WHERE S.manager = M.manager ;

Hope this helps.

-- 
David Portas
SQL Server MVP
--