SELECT u.user_id, u.first_name, u.last_name, u.company, c.company_id, c.company_name, c.type_id, c.member_DT, c.phone FROM user u, company c WHERE c.company_name LIKE u.company SELECT user_id FROM user SELECT company_id FROM company SELECT company_id, company_name from company where company_id NOT IN (#valuelist(user.company_id)#) SELECT user_id, company from user where user_id NOT IN (#valuelist(user.user_id)#) Create User company: #co_count.recordcount# user: #u_count.recordcount# #user.recordcount# #left.recordcount#

#company# || #company_name# || #company_id#
UPDATE user SET company_id = #user.company_id#, user_type_num = #user.type_id#, active=1, primary_contact='1', username='temporary', password='#paxxword#', access_start_DT=#CreateODBCDate(Now())#, access_end_DT=#CreateODBCDate(user.member_DT)# where user_id=#user_id#

#company_name# || #company_id#

#company# || #user_id#