Determining MAX Value

[Stephen Dawson]

Hi,


I have the following syntax returning the expected results.

SELECT
material.artist as "Artist",
material.title as "Title",
material.period as "Period",
material.style as "Style",
path.step as "Steps"
FROM material
INNER JOIN path ON material.id=path.material
ORDER BY period ASC, style ASC;


What I would like to do is obtain the maximum value in the path.step field. The desired outcome is to reduce the record set to only have a single record for each material.id based on its associated maximum value of path.material.

I have attempted to add MAX to path.step, but I am not successful in my syntax modification work.

Thank you in advance for your assistance.


Kindest Regards,
SHD