Re: Ideas for query

On 13/10/2011 12:17, Steve Clark wrote:
> Hello List,
>
> I am a not very experienced writing sql and I have a problem I can't
> readily solve, so
> I was hoping to get some help from this great list.
>
> Here is my problem I have a table that has event data about the status
> of units in the field. It has
> many kinds of events one of which has down time information. I have
> written a query to extract that
> information and calculate the % downtime. The problem I am having is
> that if the unit was never down
> I don't see it in my query, I would like to be able to somehow report it
> as 100% up.

The way I'd approach this is to do a LEFT OUTER JOIN between the units
table and the events table, with the units on the left of the join: this
way any particular unit will always appear in the result set, and if
there are no corresponding rows in the events table then you know that
the unit had 100% uptime.

HTH.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie