Jump to content


Photo

Can someone tell me


  • Please log in to reply
1 reply to this topic

#1 AV1611

AV1611
  • Members
  • PipPipPip
  • Advanced Member
  • 997 posts

Posted 24 November 2005 - 10:30 PM

I hope this is giving me the sum() of all records of the same Job AND Dept.

I am getting multiple rows (one per Dept) with a DEPT_HOURS for each of those rows...

I'm doing this correctly, right?

Select distinct
labor.Dept AS DEPT,
labor.Job AS MS,
countsheet.PART_NUMBER,
Sum(labor.Total) AS DEPT_HOURS,
countsheet.TOTAL AS TOTAL_QTY,
countsheet.DUE AS UNCOMP_QTY,
countsheet.NET AS COMP_QTY
From
labor,countsheet
Where
labor.Job = countsheet.MS
Group By
labor.Job,
labor.Dept
Order By
countsheet.MS Asc
;


#2 sqlmc

sqlmc
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 27 November 2005 - 03:30 PM

Try adding the remaining selected attributes to your group by clause. So it would go something like this.

Select distinct
labor.Dept AS DEPT,
labor.Job AS MS,
countsheet.PART_NUMBER,
Sum(labor.Total) AS DEPT_HOURS,
countsheet.TOTAL AS TOTAL_QTY,
countsheet.DUE AS UNCOMP_QTY,
countsheet.NET AS COMP_QTY
From
labor,countsheet
Where
labor.Job = countsheet.MS
Group By
labor.Job,
labor.Dept,
countsheet.PART_NUMBER,
countsheet.TOTAL ,
countsheet.DUE ,
countsheet.NET 
Order By
countsheet.MS Asc
;

Oh, and I'm not seeing where countsheet.MS is being selected. Using an attrute in an Order By cluase that hasn't been selected may cause unexpected results.







0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users