Are you talking about a SQL statement like this?

SELECT Description, FastTrack, Reboot, aaa.FullName AS ModifiedByFullName, bbb.FullName AS CreatedByFullName, bbb.GROUPID AS CreatedByGroupID FROM ChangeRequest, Users aaa, Users bbb WHERE ModifiedByID = aaa.UserID AND CreatedByID = bbb.UserID