ok I have a database that has couple of tables the two i need help with our.
Patientinfo and Doctorid
in the doctorid table it has fields lastname and firstname
in the patientinfo table i have one field named docname
i have redesigned this database to make a user pick the doctor from the doctorid table so there are no longer 5 different ways of spelling his name .
so this is what i need to clean it up , i need a query that looks at all the
doctors names in the patientinfo table in field docname and then compares it to all the "lastname" & "Firstname" fields in table doctorid using maybe a third field to merge lastname and firstname to one field and then give me the ones that arent there. so if there are names in the doctorid table not in patientinfo i wanna know and vica versa.