[thelist] [SQL] one query to retrieve multiple totals
Paul Bennett
paul at teltest.com
Fri Mar 28 03:29:18 CST 2003
My curent sql knowledge doesn't go much further than select, insert,
update, delete, but I'm willing to learn - really I am!
I am using MySQL version 3.23.54
I have a table which holds records of timesheet entries like so
"projectTime" table
--------------------------------
userId => numeric id of user
hours =>number of hours spent on task
taskId =>task they spent time working on
projectId => project that task belongs to
----------------------------------
I now want to produce monthly reports showing (in this case) a breakdown
of how many hours (total) a user spent on each project.
EG; I want the results => userId, projectId, hours (total) for each project.
I can do this with server side code by looping through results and doing
subqueries for each project, but a nagging voice (I do hear them from
time to time) is telling me that there must be an easier way to query
the db and get the results returned in one hit.
--
------------------------------
Paul Bennett
Internet Developer
Teltest Electronic Design
------------------------------
Email: paul at teltest.com
Phone: 64 4 237 4557
Web: http://www.teltest.com
Wap: http://wap.teltest.com
More information about the thelist
mailing list