Subject | Re: [IBO] SQL |
---|---|
Author | Svein Erling Tysvær |
Post date | 2001-09-18T08:47:12Z |
Hi Dion.
I'm surprised no-one has answered this seemingly simple question yet (at
least, I couldn't find any answer on Atkin):
SELECT SUM(Amount) AS TotAmount, c.CostItemName
FROM CostItem c
GROUP BY c.CostItemName
HTH,
Set
I'm surprised no-one has answered this seemingly simple question yet (at
least, I couldn't find any answer on Atkin):
SELECT SUM(Amount) AS TotAmount, c.CostItemName
FROM CostItem c
GROUP BY c.CostItemName
HTH,
Set