i'm setting up a system that will record passes or
fails for a given inspection.
i have created a t_inspect_result table with three
columns (to keep it simple) - inspect_id (fk to
t_inspect.inspect_id), inspect_pass (boolean),
inspect_date.
to keep it simple, let's say i have qa (quality
assurance) and ft (functional test) inspections.
i need to generate a report that will let me know if a
given serial number has any inspections that have not
yet had a pass (still a failed unit for that test node
- qa or ft).
i must add that a unit can go through qa twice... for
example
qa test 1
fail
fail
pass
ft 1
pass
... more work done ...
qa test 2
pass
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.
i think it has to do with "group," but i'm not mind
gripping the concept.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com