Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
2. All those in the CFAI list but NOT in the 123signup list>> Add them as a regular (or affiliate) SCFAS member in 123signup
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
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment