Home
Sightings
Sightings Archives

Sightings of Category Waterthrushes

select DISTINCT Report.Type, Report.ReportDate, Year([ReportDate]), Month([ReportDate]), Day([ReportDate]) from Report, ReportSpecies, Species where Report.Type = @Type and Report.ReportKey = ReportSpecies.ReportKey and ReportSpecies.SpeciesKey = Species.SpeciesKey and Species.CategoryKey = 59 ORDER BY Year([ReportDate]) DESC , Month([ReportDate]), Day([ReportDate]);   Species List