[thelist] [SQL] one query to retrieve multiple totals

[rudy]

> EG; I want the results => userId, projectId, hours (total) for each
project.

hi paul

  select userID, projectID, sum(hours)
    from projectTime
  group by userID, projectID

pretty easy, eh?

rudy