Subject Re: [IBO] Trouble with Count(*)
Author Lucas Franzen
Eric,

even easier:

SELECT SiteID, Count (*) as NumStations
from StationInfo
GROUP BY SiteID

since you don't seem to need any further fields from SiteInfo.

Luc.