jkiley (7/30/2008)

---

Consider the following QUERY:

SELECT LastName, FirstName, COUNT(TripID) TripTotal

FROM Clients

JOIN Trips on tripClientID = ClientID

JOIN Accounts on accountClientID = ClientID

WHERE (tripDate BETWEEN '06-01-08' AND '06-30-08') AND (accountID = 501)

GROUP BY...