Distinct column in an inner join query sql
this will give image only

SELECT 
   max(ArchiveCatalogues.IMAGE),    
   artist.surname,
   artist.firstnames,
   artist.dates,
   artist.honorific,
   artist.biog
FROM ArchiveCatalogues 
INNER JOIN artist
 ON (ArchiveCatalogues.ARTIST    = artist.surname)
AND (ArchiveCatalogues.FIRSTNAME = artist.firstnames) 
group by 
   artist.surname,
   artist.firstnames,
   artist.dates,
   artist.honorific,
   artist.biog