SELECT ; Equipinv.mfg, Equipinv.model, Equipinv.sernum, Stumaint.clsdate,; Stumaint.trhrs, Stumaint.drhrs, Stumaint.udrum, Stumaint.proller,; Stumaint.froller, Stumaint.slpring, Stumaint.brushes, Stumaint.ctlhd,; Stumaint.audhd; FROM ; eng!equipinv ; INNER JOIN eng!stumaint ON Equipinv.cmaster_index = Stumaint.cmaster_index ; WHERE ; stumaint.udrum = .T. AND ; stumaint.clsdate = ; (SELECT MAX(stutemp.clsdate) ; FROM stumaint stutemp ; WHERE stutemp.cmaster_index=stumaint.cmaster_index) ; INTO ; CURSOR result(If this message solved your problem, please click on the "Mark this message as the answer to the thread" hyperlink below... Thanks).