excluding data from from return.

[Liquid Fire]

here is my query:

 

select COUNT(sr.TID) as t_count, r.Email FROM SalesReport sr INNER JOIN SalesReps r ON r.RepCode = sr.RepCode GROUP BY sr.RepCode HAVING t_count <= 19 AND t_count >= 15

 

is there a way to exclue the t_count from showing up in the returned result?  I am just wondering becuase the only reason i need that there is to get the count, don't need the data passed that point.

[monk.e.boy]

Why do you want to remove it?

 

If it is screwing up your indexed data, then move it so it is the last item to be SELECTed. Then email will be $row[0], and count will be $row[1]

 

If you are removing it for optimization, then don't bother.

 

monk.e.boy