I have two tables that i'm trying to match a person to. Both tables have NPI which I can link to, but if the NPI is missing out of one or both of the tables, then I want it to search for other fields to match. I want it to then look at last name, then first name, then address
so it would be tblA and tblB
if NPI = NPI else Last Name = Last Name else Address = Address
How would I go about writing this code?