SQL MAX() to return a different value

See more:

MySQL

Hello,
I have a table with the file location of images and their sizes as fields. I want to return the fiel location field of the largest image. Using MAX(fieldsize) gets me the right record, but how do I return a different field?

SELECT MAX(fldItemSize) FROM tblItemImagePaths
    WHERE fldSupplierID = @SupplierID
    AND fldSupplierCode = @SupplierCode

when I include the requried field, the query then returns two lines of data. Yes, I'm new to this :)

SELECT        MAX(fldItemSize) AS Expr1, fldItemPath
FROM            tblItemImagePaths
WHERE        (fldSupplierID = @SupplierID) AND (fldSupplierCode = @SupplierCode)
GROUP BY fldItemPath