Still throwing an error:

Msg 102, Level 15, State 1, Line 10

Incorrect syntax near ')'.

WITH CTE_Concat AS (

SELECT lb.ListID, lmb.EntityID,

STUFF((SELECT '; ' + lb.ListName

FROM ReznickGroup_MSCRM.dbo.ListMemberBase lmb

INNER JOIN ReznickGroup_MSCRM.dbo.ListBase lb ON lb.listid = lmb.listid

WHERE lmb.entityid = cb.contactid

FOR XML PATH('')),1,1,'') AS ConcatValues

FROM ReznickGroup_MSCRM.dbo.ContactBase cb

)