Displaying 1 result from an estimated 1 matches for "tf1951400".
2006 Jul 16
4
Calculations across multiple tables
..._at)) / 3600) AS total_client_hours
FROM clients, tasks, time_records
WHERE tasks.client_id = clients.id AND time_records.task_id = tasks.id
GROUP BY client_id, project_id, task_id WITH ROLLUP;
--
View this message in context: http://www.nabble.com/Calculations-across-multiple-tables-tf1951400.html#a5351226
Sent from the RubyOnRails Users forum at Nabble.com.