Re: How To Exclude True Values

> hi all,
> 
> how can i exclude true values for this query?
> 
> http://www.rafb.net/paste/results/obtkGz26.html
> 
> if i uncomment out 
> 
> --    AND t_inspect_result.inspect_result_pass = 'f'
> 
> it looks for prior falses within an inspect_id and
> returns it.  i want the original result set minus
> the
> trues, if possible.
> 
> tia...

this SQL appears to do the trick...

http://www.rafb.net/paste/results/zZKIjH80.html

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com