This content has been marked as final. Show 2 replies
I have 2 tables that I want to load, one is a table of medical claims and one is a list of registered pharmacies, the common field is Pharmacy registration numbern which is assigned to each claims line in the claims file and is part of the record for each registered pharmacy. . I want to load all claims from the claims file for Pharmacies that are not registered, so do not have a record in the list of registered pharmacies. The fields in the claims file are - Registration number, date, amount charged, amount paid, member and the fields in the registered pharmacies list are - Registration number, Pharmacy name, State where Pharmacy resides. I won't to just load the records in the first table where the regustration number os not found int he second table.