Re: SQL Question

On Wed, May 24, 2006 at 15:06:53 -0700,
  operationsengineer1@yahoo.com wrote:
>
> given this structure, and hopefully i've communicated
> it well enough, i'm concerned that it might be
> difficult to weed out qa 1 fail followed by qa 2 pass.
>
> that is...
>
> qa test 1
> fail
>
> ... the bizrre happens ...
>
> qa test 2
> pass
>
> how can i go about finding the qa test 1 failure?
>
> if i did a inspect_date descending query with a limit
> of 1, i'd get a pass and miss the failure.

Use "inspect_pass" in the WHERE clause.