SELECT M.*,
  M.AnalysisLookupID,  LTRIM(RTRIM(replace(comments ,'same as id ', '')))
FROM
  [GroupsDetail] AS M
INNER JOIN
  AnalysisLookup L
ON
  M.[AnalysisLookupID] = L.[AnalysisLookupID]
     where M.AnalysisLookupid  in (17,93)
GO
SELECT  M.*,
  M.AnalysisLookupID ,LTRIM(RTRIM(replace(comments ,'same as id ', '')))
FROM
  AnalysesAdditionalLookupDetail AS M
INNER JOIN
  AnalysisLookup L
ON
  M.[AnalysisLookupID] = L.[AnalysisLookupID]
      where M.AnalysisLookupid  in (17,93)