Query: Select person that should be match in Blacklist

Select distinct [BlacklistedAlias].[FirstName] + ' ' + [BlacklistedAlias].[LastName]
From [BlacklistedAlias] Inner Join [Blacklisted] On [BlacklistedAlias].[BlacklistedId] = [Blacklisted].[Id]
Where [Blacklisted].[TableNumber] = 17 And ([BlacklistedAlias].[FirstName] + ' ' + [BlacklistedAlias].[LastName] in (
Select [Person].[FirstName] + ' ' + [Person].[LastName]
from [DeMaSy].[DeMaSy].[Person] as [Person] where [Person].[DBId] = XX) or [BlacklistedAlias].[LastName] + ' ' + [BlacklistedAlias].[FirstName] in (
Select [Person].[LastName] + ' ' + [Person].[FirstName]
from [DeMaSy].[DeMaSy].[Person] as [Person]
where [Person].[DBId] = XX )) Order by [BlacklistedAlias].[FirstName] + ' ' + [BlacklistedAlias].[LastName]

Delete Record that should be match and where MatchPercentage is 0

Delete from Blacklist
where PersonId in
(select Person.Id
from DeMasy.Person as Person
Inner Join Licence.DeMaSy.Blacklisted as Blacklisted
On Person.LastName = Blacklisted.LastName and Person.FirstName = Blacklisted.FirstName and TableNumber = 17
where Person.DBId = XXX)
and Blacklist.DBId = XXX and Blacklist.MatchPercentage = 0

Delete from Blacklist
where CompanyId in
(select Company.Id
from Company
Inner Join Licence.DeMaSy.Blacklisted as Blacklisted
On Company.Name = Blacklisted.FirstName and TableNumber = 2
where Company.DBId = XXX)
and Blacklist.DBId = XXX and Blacklist.MatchPercentage = 0