Query 1
---------

SELECT List(Name) AS ContactRoleList
  FROM ContactRoles
     INNER JOIN RoleTypes ON ContactRoles.RoleTypeID = RoleTypes.ID
  WHERE ContactID = 10968
  GROUP BY ContactID

Gives a NULL ContactRoleList which is correct.

Query 2
---------

Take the GROUP BY clause out, then obtain different results.

SELECT List(Name) AS ContactRoleList
  FROM ContactRoles
     INNER JOIN RoleTypes ON ContactRoles.RoleTypeID = RoleTypes.ID
  WHERE ContactID = 10968

Gives a ContactRoleList of Vendor Solicitor - Vendor Solictor is the first
item in ContactRoles table.