select distinct rl.Id,

rl.AlarmId, rl.Name

From T.dbo.BHI_Alarm ra with (nolock)

Inner Join T.dbo.BHI_Library rl with (nolock)

On rl.id = ra.id

and rl.BatchId = ra.BatchId

and rl.nameid = @nameid

and rl.AId = @AId

and (ra.memberid = @memberid or ra.CustomerId = @cid)