SELECT DISTINCT dbo.Claim.ClaimRef,
       dbo.Claim.MasterRef,
       dbo.Claim.CustomerRef, 
       dbo.Claim.CreditorName,
       dbo.Claim.PayDetailsID, 
       dbo.PaymentDetails.PayeeName,
       dbo.PaymentDetails.PayAddressID,
       dbo.Address.AddressType                 AS PayAddressType,
       dbo.Address.AddrLine1                   AS PayAddrLine1,
       dbo.Address.AddrLine2                   AS PayAddrLine2,
       dbo.Address.AddrLine3                   AS PayAddrLine3,
       dbo.Address.AddrLine4                   AS PayAddrLine4,
       dbo.Address.CountryCode                 AS PayCountryCode,
       dbo.Address.AmendDate                   AS PayAddrAmendDate,
       dbo.Address.AmendUser                   AS PayAddrAmendUser,
       dbo.PaymentDetails.ForceTT,
       dbo.PaymentDetails.TTBankName,
       dbo.PaymentDetails.TTBankAddress,
       dbo.PaymentDetails.TTSortCode,
       dbo.PaymentDetails.TTBenificiary,
       dbo.PaymentDetails.TTAccountNo,
       dbo.PaymentDetails.TTIBANNo,
       dbo.PaymentDetails.TTInstructions,
       dbo.PaymentDetails.TTAmendDate,
       dbo.PaymentDetails.TTAmendUser, 
       dbo.PaymentDetails.TTDetailsConf,
       dbo.PaymentDetails.TTDetailsConfDate,
       dbo.PaymentDetails.TTDetailsConfUser,
       dbo.PaymentDetails.AmendDate            AS PayDetailsAmendDate,
       dbo.PaymentDetails.AmendUser            AS PayDetailsAmendUser,
       dbo.Master.PayDetailsRequestLetterDate,
       dbo.Claim.PayDetailsConf,
       dbo.Claim.PayDetailsConfDate,
       dbo.Claim.PayDetailsConfUser,
       dbo.Claim.AmendDate,
       dbo.Claim.AmendUser,
       CASE WHEN multiblk.Clm_Ref IS NULL THEN 0 ELSE 1 END AS Deceased
FROM dbo.Master
     INNER JOIN dbo.Claim          ON dbo.Master.MasterRef = dbo.Claim.MasterRef 
     INNER JOIN dbo.Address        ON dbo.Address.AddressID = dbo.PaymentDetails.PayAddressID
     INNER JOIN dbo.PaymentDetails ON dbo.Claim.PayDetailsID = dbo.PaymentDetails.PayDetailsID
     LEFT  JOIN lcs5...multiblk  multiblk 
                ON Multiblk.clm_ref = dbo.Claim.ClaimRef AND multiblk.Block = '94 AND multiblk.Active = 1
ORDER BY dbo.Claim.MasterRef

SELECT DISTINCT dbo.Claim.ClaimRef,
       dbo.Claim.MasterRef,
       dbo.Claim.CustomerRef, 
       dbo.Claim.CreditorName,
       dbo.Claim.PayDetailsID, 
       dbo.PaymentDetails.PayeeName,
       dbo.PaymentDetails.PayAddressID,
       dbo.Address.AddressType                 AS PayAddressType,
       dbo.Address.AddrLine1                   AS PayAddrLine1,
       dbo.Address.AddrLine2                   AS PayAddrLine2,
       dbo.Address.AddrLine3                   AS PayAddrLine3,
       dbo.Address.AddrLine4                   AS PayAddrLine4,
       dbo.Address.CountryCode                 AS PayCountryCode,
       dbo.Address.AmendDate                   AS PayAddrAmendDate,
       dbo.Address.AmendUser                   AS PayAddrAmendUser,
       dbo.PaymentDetails.ForceTT,
       dbo.PaymentDetails.TTBankName,
       dbo.PaymentDetails.TTBankAddress,
       dbo.PaymentDetails.TTSortCode,
       dbo.PaymentDetails.TTBenificiary,
       dbo.PaymentDetails.TTAccountNo,
       dbo.PaymentDetails.TTIBANNo,
       dbo.PaymentDetails.TTInstructions,
       dbo.PaymentDetails.TTAmendDate,
       dbo.PaymentDetails.TTAmendUser, 
       dbo.PaymentDetails.TTDetailsConf,
       dbo.PaymentDetails.TTDetailsConfDate,
       dbo.PaymentDetails.TTDetailsConfUser,
       dbo.PaymentDetails.AmendDate            AS PayDetailsAmendDate,
       dbo.PaymentDetails.AmendUser            AS PayDetailsAmendUser,
       dbo.Master.PayDetailsRequestLetterDate,
       dbo.Claim.PayDetailsConf,
       dbo.Claim.PayDetailsConfDate,
       dbo.Claim.PayDetailsConfUser,
       dbo.Claim.AmendDate,
       dbo.Claim.AmendUser,
       CASE WHEN multiblk.Clm_Ref IS NULL THEN 0 ELSE 1 END AS Deceased
FROM dbo.Master
     INNER JOIN dbo.Claim          ON dbo.Master.MasterRef = dbo.Claim.MasterRef 
     INNER JOIN dbo.Address        ON dbo.Address.AddressID = dbo.PaymentDetails.PayAddressID
     INNER JOIN dbo.PaymentDetails ON dbo.Claim.PayDetailsID = dbo.PaymentDetails.PayDetailsID
     LEFT  JOIN (SELECT clm_ref FROM lcs5...multiblk WHERE  Block = '94 AND Active = 1) multiblk 
                ON Multiblk.clm_ref = dbo.Claim.ClaimRef
ORDER BY dbo.Claim.MasterRef