Take a ID from One ID based put related all ID of ...like AlbummasterID based on all primary ID get

DECLARE @ValueList varchar(max)
select @ValueList = COALESCE(@ValueList + ', ', '') +
   CAST(BookIssueMc.BookIssueID AS varchar(max))
from BookIssueMc where Amount > 0
--print @ValueList