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

["IraMSN" <webforumsuser@xxxxxxxxxxxxxx>]

OK, that fixed the error. I should have spotted that. 

 Do I have the next part of the code correct? It isn't inserting:

 <cfloop query ="qryMember">
 insert into NetNewsTest (Email_address, First_Name, Last_Name, MemberNumber)
 values ('#trim(qryMember.Email)#', '#trim(qryMember.FirstName)#', 
'#trim(qryMember.LastName)#', '# trim(qryMember.MemberNumber)#')
 </cfloop>