sql语句:
SELECT Max(ttt.RegDate) AS RegDatemax, ttt.UserCode
FROM (SELECT tt1.WrkOrder, tt1.OrderNo, tt1.Style, tt2.UserCode, tt2.RegDate, tt3.Fpaixu
FROM ((SELECT t1.WrkOrder,t1.OrderNo, t1.Style, t2.Fcsgp, t2.FzhugxId
FROM (pywrkord AS t1 INNER JOIN pywrkstp AS t3 ON t1.WrkOrder = t3.WrkOrder) INNER JOIN pypttgx AS t2 ON t3.StepNo = t2.FgongxuId
WHERE t1.OrderNo='PTT-05' AND t1.Style='PTT-17A2605' AND t2.Fcsgp=1) AS tt1 INNER JOIN pytckreg2 AS tt2 ON tt1.WrkOrder = tt2.WrkOrder) INNER JOIN pypttgx AS tt3 ON (tt1.FzhugxId = tt3.FzhugxId) AND (tt2.UserCode = tt3.Fgongxu)) AS ttt
GROUP BY ttt.UserCode