Refactor Query...

hi all,

i'm trying to refactor this query:

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

i've added notes to make its function a bit more
clear. i have trie dto refactor it to get rid of the
"distinct on" function, but i've had no luck.

due to all the WHERE clauses, i can't figure out how
to do an inner join with something like this:

select max(t_inspect_result.inspect_result_timestamp)
as mstamp,
t_inspect_result.inspect_id
from t_inspect_result
group by t_inspect_result.inspect_id
) AS b

thanks in advance...

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