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