> inspect_id, inspect_result_id, inspect_result_pass,
> inspect_result_timestamp
> 3, 5, f, 2006-06-05 05:00:00
> 3, 6, t, 2006-06-05 06:00:00
> 4, 7, f, 2006-06-05 07:00:00
> *4, 8, f, 2006-06-05 08:00:00*
> the query linked in this post will return 3 lines...
>
> 1, 2, f
> 3, 5, f
> *4, 8, f* -- the only one i really want
From your sample it seems to me that you are really only looking for the most recient occuring
record that have produced a false test regardless of which Inspect_id or inspect_result_id it came
from. Is this correct?
Regards,
Richard Broersma Jr.