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

["Dan Bracuk" <webforumsuser@xxxxxxxxxxxxxx>]

Forget the duplicates for right now.  We'll do something easy first.

 Run your 2nd query first.

 Then, when you run the qryMember query, add this to the where clause.

 and membernumber not in (<cfqueryparam list="yes" 
value="#valuelist(newsmember.membernumber)# cfsqltype="cf_sql_integer">)

 Then, for your inserts, just loop through the qryMember query.  You don't need 
any if/else logic.