Help with SELECT statement

[eluser]bgreene[/eluser]
it doesen't 8=) and probably doesn't need to. the data should all be in the downtime table. to check the downtime for a specific device just do a "select x,y,z, sum(timedown) from etc where device_id = 'the deviceid to check' group by device_id".
the "sum" function requires "group by". you can also omit the "where" and get a listing for all devices but then add eg "order by devicename" or whatever so it looks nice