select
count(r.reportId) as reportCount,
v.vehicleName,
c.companyName
from
reports r
left outer join vehicleTable v on v.ipAddressNumber = r.ipAddressNumber
inner join companyTable c on c.companyIdnumber = r.companyId
where
r.companyId = 1
and
r.date between '07/11/2004 00:00:00.000' and '07/13/2004 23:59:59.999'
group by
vehicleName, companyName
order by
reportCount desc
<snip>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
