2. All those in the CFAI list but NOT in the 123signup list>> Add them as a regular (or affiliate) SCFAS member in 123signup

in_cfai_not_in_123signup.sql

SELECT
cfai.display_name, cfai.first_name, cfai.last_name, cfai.email

FROM 
    from_cfai cfai

WHERE cfai.email NOT IN (
        SELECT onetwothree.email
        FROM 
            from_123 onetwothree
        WHERE cfai.email = onetwothree.email
    )

/* using the new CFAI file  as of December 10, 2011
and new 123signup file containing all members from December 11, 2011*/
SELECT
cfai.first_name, 
cfai.last_name, 
cfai.email, 
cfai.home_phone,
cfai.work_phone,
"Password123" as temp_password,
cfai.street_address,
cfai.street_address_2,
cfai.street_address_3,
cfai.city,
cfai.state,
cfai.zip,
cfai.person_id,
cfai.member_type

FROM 
    from_cfai_20111201 cfai


WHERE cfai.email NOT IN (
        SELECT onetwothree.email
        FROM 
            from_123_20111211 onetwothree
        WHERE cfai.email = onetwothree.email
)