looking for query

[prodadmin]

hi ,I am looking for a query.
table rder_history
order_id -revisons-date
2345 -2- 12/31/2007 11:05:AM
2345-3-12/31/2007 11:06:AM
2345-4--12/31/2007 11:07:AM
2345-5-12/31/2007 11:08:AM

2346-3-12/30/2007 11:05:AM
2346-4-12/30/2007 11:05:AM

2347 -2--12/31/2007 11:05:AM
2348 -3-12/31/2007 11:05:AM
##############################################
order_parts_history
order_id - revisions-parts orderd- date

2345-3-2-12/31/2007 11:09:AM
2345-4 -4-12/31/2007 11:10:AM
2345-5-0-12/31/2007 11:11:AM

2346-3--4-12/30/2007 11:10:AM
2346-4-5-12/30/2007 11:14:AM

2347 -2-0-12/31/2007 11:15:AM
2348 -3-4-12/31/2007 11:17:AM
#############################################
i am looking for results where max revision in order_history with parts(not equal to zero)
2345-4 -4-12/31/2007 11:07:AM(this date from order_history)
2346-4-5-12/30/2007 11:05:AM
2348 -3-4-12/31/2007 11:05:AM

any help is much appreciated

Thank you

[PAVB]

Shall we understand you want somebody to do your job?
Why you don't show us your best effort?

[prodadmin]

yes please , can you do my job !! i am not being rude here ..but if you want help just help otherwise don't worry about the post,don't reply ..or you just trying to increase posts ..

many thanks for your REPLY

i got the results i was looking for by using subquery

[PAVB]

You are more than welcome. I love you too!

By the way... it looks like I did the right thing, it turns out you knew how to do it and you just needed a little help to move your lazy a$$

Way to go, I'm so proud of you