Results 1 to 7 of 7
Thread: Is this query possible??
Jan 24, 2002, 06:36 #1
- Join Date
- Mar 2001
- London | UK
- 0 Post(s)
- 0 Thread(s)
Is this query possible??
Ok, from this basic query that select ALL unbilled items from the unbilled_item table along with the respective project manager for each job from the job table, is it possible to sum the unbilled_item.amount's associated with each unbilled_item.job_number and then order by this total.
So, I am trying to list jobs by total unbilled amount.
$sql = " SELECT unbilled_item.job_number,unbilled_item.week_ending,unbilled_item.amount,job.project_manager FROM unbilled_item LEFT JOIN job ON (unbilled_item.job_number=job.job_number) " ;