...
Code Block | ||
---|---|---|
| ||
SELECT
ActivityT.SiteID,
ActivityT.FieldDate,
ActivityT.StreamWidthInFeet,
ActivityT.AverageDepthInFeet,
ActivityT.[AverageStreamVelocityInFeet/Second],
ActivityT.[%Bedrock], ActivityT.[%Boulder],
ActivityT.[%Clay], ActivityT.[%Cobble],
ActivityT.[%Gravel], ActivityT.[%Sand],
ActivityT.[%Silt], ActivityT.[%OtherSubstrate],
ActivityT.[1stHabitatSampled], ActivityT.[2ndHabitatSampled]
ActivityT.Flatworm, ActivityT.AquaticWorm,
ActivityT.Leech, ActivityT.Sowbug,
ActivityT.Scud, ActivityT.Dragonfly,
ActivityT.BroadwingedDamselfly, ActivityT.NarrowwingedDamselfly,
ActivityT.Dobsonfly, ActivityT.Alderfly,
ActivityT.TorpedoMayfly, ActivityT.SwimmingMayfly,
ActivityT.ClingingMayfly, ActivityT.CrawlingMayfly,
ActivityT.BurrowingMayfly, ActivityT.ArmoredMayfly,
ActivityT.OtherMayfly, ActivityT.Stonefly,
ActivityT.HydropsychidCaddisfly, ActivityT.SnailCaseCaddisfly,
ActivityT.SaddlecaseCaddisfly, ActivityT.OtherCaddisfly,
ActivityT.RiffleBeetle, ActivityT.WhirligigBeetle,
ActivityT.WaterPennyBeetle, ActivityT.Cranefly,
ActivityT.BitingMidge, ActivityT.BloodwormMidge,
ActivityT.Midge, ActivityT.Blackfly,
ActivityT.Snipefly, ActivityT.OtherFly,
ActivityT.LefHandedSnail, ActivityT.RightHandedSnail,
ActivityT.PlanorbidSnail, ActivityT.Limpet,
ActivityT.OperculateSnail,
SiteT.SiteID,
SiteT.SiteName,
SiteT.Latitude,
SiteT.Longitude
FROM ActivityT
INNER JOIN SiteT ON ActivityT.SiteID=SiteT.SiteID;
|
...