[Tfug] Database file import/consolidation

[Choprboy]

On Thursday 15 July 2004 18:56, keith smith wrote:
> Adrian,
>  
> Do you assign a unique key to each customer?  Are they customer numbers?
>  

Well, yes and no. In other tables, each customer has a unique key and there is 
only one instance of each user (actually, there are multiple copies of the 
same customer, to be fixed later, but they are considered unique customers).

But I have to check our customers being processed for matches against this 
table provided by an external 3rd party, which may contain multiple records 
for the same customer, has no unique keys, and I can not get them to provide 
a "uniqueness". Add to that, I have to do "fuzzy-ish" query against it to 
catch name/etc. variations between the local and 3rd party tables.

Adrian