The query below is returning the data, but I need to group it on PrimaryCarrier/iTableID. Here is the output of the current query:

NumberPerformed PrimaryCarrier                                     iTableID    timeused    AvgORCost                                avgResCost                               
--------------- -------------------------------------------------- ----------- ----------- ---------------------------------------- ---------------------------------------- 
1               N/A                                                NULL        102         465.120000                               304.940000
1               N/A                                                NULL        100         456.000000                               516.100000
1               N/A                                                NULL        100         456.000000                               450.390000
1               N/A                                                NULL        105         478.800000                               304.940000
1               N/A                                                NULL        117         533.520000                               304.940000
1               N/A                                                NULL        30          136.800000                               .000000
1               N/A                                                NULL        90          410.400000                               304.940000
1               N/A                                                NULL        110         501.600000                               471.530000
1               N/A                                                NULL        103         469.680000                               471.530000
1               N/A                                                NULL        115         524.400000                               471.530000
1               N/A                                                NULL        100         456.000000                               304.940000
1               EVERGREEN HEALTH PLAN                              18          100         456.000000                               516.100000

In this case, I only want two rows, one for N/A and one for Evergreen.

Here is the query I've built:

declare @ltQueryFrom  datetime
declare @ltQueryTo datetime

set @ltQueryFrom = '04/01/2002 00:00:00'
set @ltQueryTo   = '04/05/2002 23:00:00'

SELECT     count(meetproc.procid) as NumberPerformed,
	   isnull(dbo.itable.company,'N/A') as PrimaryCarrier, iTableID,
	   avg(datediff(mi,meetings.enteror,meetings.exitor)) as timeused,
	   avg(datediff(mi,meetings.enteror,meetings.exitor) * meetings.DeptCostPerMinute) as AvgORCost,
  	   (select isnull(sum(cocasedata.itemunitcost * coCaseData.ActualQty),0)/count(meetproc.procid) 
		FROM dbo.meetings t3 INNER JOIN 
                dbo.meetproc t4 ON t3.meetingnumber = t4.meetingnumber INNER JOIN 
                dbo.cocasedata ON t3.meetingnumber = dbo.cocasedata.meetingnumber 
		where t3.meetingnumber=meetings.meetingnumber 
		and t3.iscompleted=1) as avgResCost
FROM         dbo.patients INNER JOIN
             dbo.meetings ON dbo.patients.patientid = dbo.meetings.patientid INNER JOIN
             dbo.meetproc ON dbo.meetings.meetingnumber = dbo.meetproc.meetingnumber LEFT OUTER JOIN
             dbo.itable ON dbo.patients.primarycarrierid = dbo.itable.itableid
where meetings.begintime between @ltQueryFrom and @ltQueryTo 
and meetings.iscompleted=1 
and meetproc.procid=7141
group by iTableID,company,meetings.meetingnumber
order by Company

Thanks for any help