help with sql statement

I

ifoundgoldbug

Greetings

I have a table arranged thusly

Reason Status Est Comp Date PMDate Tool#
7/14/06 WFT083
Maintence done 7/16/06 WFT083

what my sql statement MUST do is search by Tool # then find the most
recent PMDate then find if there is a work order with finished
maintence with a complete date AFTER the PMdate. also the returning
record will be a seperate record from the one with the PM date.

thanks for your help.
 
Top