General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks for the reply. I'm on the right track, but lack the syntax ability. I have the following query:
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.
( I have omitted the ORDER BY )
I need to display only the MAX(DTOS(stumaint.clsdate)) for each equipinv.sernum.
The query above gets me very close, but displays multiple records for each
equipinv.sernum
Any help is greatly appreciated
Bruce Covey
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only