Re: Importing and Updating Non-Duplicate Records from 2 Tables

["IraMSN" <webforumsuser@xxxxxxxxxxxxxx>]

Membernumber is not the primary key. I'm not understanding how filtering 
MemberNumber in the first query would correct the error. If the database has no 
records, it gets the error. After an import, when you do another import, it 
gets the error with no updates.

 Changes to an email address happens in 2 ways. By the user updating his own 
email address from a webpage GUI or our membership department updating the 
email address from a webform on our company Intranet and then it replicates to 
our webserver database.

 We would just have to compare emails matched to the membernumber and update it 
where necessary.