Code: Select all
SQL SELECT E.,M.Name AS MonitorName,M.DefaultScale
FROM Monitors AS M INNER JOIN Events AS E ON (M.Id = E.MonitorId)
WHERE
E.TotScore > '30' and / AlarmedZoneId / EXISTS (SELECT * FROM Stats WHERE EventId=E.Id AND ZoneId=3 AND Score > 0)
and / AlarmedZoneId */ EXISTS (SELECT * FROM Stats WHERE EventId=E.Id AND ZoneId=2 AND Score > 0) ORDER BY StartDateTime ASC
Should this not be Score = 0 ?
Thank you, Chris