Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
Select C.FirstName as 'FirstName', C.LastName as 'LastName', F.FirmName as 'Firm', C.Email From Contacts C JOIN Firms F ON C.FirmNo = F.FirmNo JOIN State S ON S.StateNo = F.StateNo Where C.NoMarketing = 0 AND C.Email != '' AND CASE @State WHEN @State like 'California - Northern Cali' THEN F.PostCode BETWEEN 93000 AND 96000 ELSE S.StateName = @State END Select S.StateName as 'StateName' From State S Where S.[Disabled] = 0 AND CountryNo = 295 AND StateNo NOT IN (159,162,160,161) UNION Select 'California - Northern Cali' From State S Where S.[Disabled]=0
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!