peskywinnets
Registered User.
- Local time
- Today, 11:54
- Joined
- Feb 4, 2014
- Messages
- 578
So I'm having some diffs grasping something that is probably fundamental to getting to grips with databases!
I wish to establish some unmatched records...customer address information to be precise.
So, a new customer gets appended to an incoming 'scratch' table. Towards normalising the data, I firstly need to check if this customer exists in the customer table, so I've set up three queries...
Query 1 pulls out Unique records (to avoid duplicates) from the scratch table
Query 2 checks to see which of the above are unmatched in the Customer Table
Query 3 Actually appends the above the unmatched to the customers table
Is my approach correct?
Ok, assuming it is ....sometimes the customer doesn't put an entry for 'address line 2' ...but many do & because of this I therefore ought to find 'unmatched' to include 'address line 2' as well ....but if some customers haven't entered anything (null) then how can I find unmatched entries in the customer table against the value?
I wish to establish some unmatched records...customer address information to be precise.
So, a new customer gets appended to an incoming 'scratch' table. Towards normalising the data, I firstly need to check if this customer exists in the customer table, so I've set up three queries...
Query 1 pulls out Unique records (to avoid duplicates) from the scratch table
Query 2 checks to see which of the above are unmatched in the Customer Table
Query 3 Actually appends the above the unmatched to the customers table
Is my approach correct?
Ok, assuming it is ....sometimes the customer doesn't put an entry for 'address line 2' ...but many do & because of this I therefore ought to find 'unmatched' to include 'address line 2' as well ....but if some customers haven't entered anything (null) then how can I find unmatched entries in the customer table against the value?