invokanaLoadMatchCompare.sql

use stage
go
  
select *
from d_originalJanssenInvokana as c
where not exists (select * from d_janssenInvokana as v
                  where v.firstName = c.[First Name]
                    and v.lastName = c.[last name]
                    and v.add1 = c.[Business Address 1]
                    and v.add2 = c.[Business Address 2]
                    and v.addCity = c.[Business City]
                    and v.addState = c.[Business State]
                    and v.addZip = c.[Business Zip Code]
                    and v.email = c.[Email]
                    and v.phone = c.[Phone])