select
    p.ID ,
    p.Name ,
    p.Family ,
    p.Address
from
    dbo.Persons p
    join dbo.PrivacyOnPerson pp
    on p.ID = pp.PersonID
where
    p.FREETEXT(Address,"NEWYork") and
    pp.AddressPrivacy = 0x0