I'm kind of a SQL newbie so please pardon me if this is too trivial. I have a time tracking DB which is set up as below, with personnel related to projects related to tasks. I need to retrieve and group total minutes per project as well as total minutes per person based on a given time period. I can't seem to come up with the proper queries. Can anyone help?
Thanks so much. John Venable I'm looking for: Project 1 -- Total Time (for DataRange) Project 2 -- Total Time (for DataRange) Project 3 -- Total Time (for DataRange) .. And Person 1 -- Total Time (for DataRange) Person 2 -- Total Time (for DataRange) Person 3 -- Total Time (for DataRange) .. -------------------------- -------------------------- | Personnel | | Projects | -------------------------- -------------------------- |**| Personnel_ID | |**| Project_ID | | | First_Name | | | Personnel_ID | | | Last_Name | | | Project_Name | | | Login | | | Project_Description | | | Password | -------------------------- -------------------------- -------------------------- | Tasks | -------------------------- |**| Task_ID | | | Project_ID | | | Task_Description | | | Start_Time | | | End_Time | | | Total_Minutes | -------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/sql Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
