max(date) and grouping issue

I am connecting to a sql server using jdbcr4 service program.

I have the following query

SELECT SMSCD, SMCLO, SMPRM, b.locationdescription, c.FacilityID, c.comments max(c.completiondate)
FROM [Orders].[GISOwner].[SERVICEORDERS] a left outer join
[orders].[gisowner].[exposedgaspipe] b on smprm = premisenumber left outer join
[orders].[gisowner].[exposedpipeinspections] c on b.FacilityID = c.facilityid
where SMSCD = 'EMM' and SMCLO = ' '
group by SMSCD, SMCLO, SMPRM, b.locationdescription, c.facilityID

This seems to be working ok, but when I add an additional field(comments) to be selected, I start getting extra records from the C file.

SELECT SMSCD, SMCLO, SMPRM, b.locationdescription, c.FacilityID, max(c.completiondate)
FROM [Orders].[GISOwner].[SERVICEORDERS] a left outer join
[orders].[gisowner].[exposedgaspipe] b on smprm = premisenumber left outer join
[orders].[gisowner].[exposedpipeinspections] c on b.FacilityID = c.facilityid
where SMSCD = 'EMM' and SMCLO = ' '
group by SMSCD, SMCLO, SMPRM, b.locationdescription, c.facilityID, c.comments

This is probably something silly, but I can't get it to work.

Mike
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.