select jobtran.trans_date
	,job.job
	,job.suffix
	,job.item
	,jobtran.wc
	,Sum(jobtran.qty_complete) as Gross_qty
	,(Select top 1 qty_complete as Net_Qty from GAI_Previous_Job_Info where GAI_Previous_Job_Info.job = job.job and 
	  GAI_Previous_Job_Info.suffix = job.suffix - 1) as net_qty 
     ,(Select top 1 unit_weight from GAI_Previous_Job_Info where GAI_Previous_Job_Info.job = job.job and 
	  GAI_Previous_Job_Info.suffix = job.suffix - 1) as unit_weight
	,Sum(CASE When jobtran.trans_type = 'C' Then a_hrs Else 0 End) as run_hrs 
	from job,jobtran
	where jobtran.wc BETWEEN @WCStart and @WCEND and jobtran.trans_date BETWEEN @PStartingTranDate and @PEndingTranDate 
		and jobtran.job = job.job and jobtran.suffix = job.suffix
		and jobtran.trans_type in('R','C')
		
	group by jobtran.trans_date,job.job,job.suffix,job.item,jobtran.wc
	order by jobtran.wc

quote:

---

Originally posted by Kristen

So jobtran.trans_date is not unique for all the other values you want to show?

If so use:

SELECT MIN(jobtran.trans_date) AS trans_date

and drop it from the GROUP BY list.

Or you could use AVERAGE(jobtran.trans_date) if you prefer

---