[SOLVED] UPDATE Query with Auto Actions

UPDATE `j25_virtuemart_userinfos` SET `virtuemart_user_id`='[user_id]',`company`=IFNULL('[company]',`company`),`title`=IFNULL('[title]',`title`),`last_name`='[lastname]',`first_name`='[firstname]',`middle_name`=IFNULL('[middlename]',`middle_name`),`phone_1`=IFNULL('[phone]',`phone_1`),`fax`=IFNULL('[fax]',`fax`),`address_1`=IFNULL('[location]',`address_1`),`address_2`=IFNULL('[address]',`address_2`),`city`=IFNULL('[city]',`city`),`virtuemart_state_id`=IFNULL('[state]',`virtuemart_state_id`),`virtuemart_country_id`=IFNULL('[cb_select_country]',`virtuemart_country_id`),`zip`=IFNULL('[zipcode]',`zip`) WHERE `virtuemart_user_id`='[user_id]';

UPDATE `j25_virtuemart_userinfos` v inner join j25_comprofiler c on v.virtuemart_user_id= c.user_id SET `name`=c.firstname + ' '+ c.lastname,v.company=c.company,`last_name`=c.lastname,`first_name`=c.firstname,`middle_name`=c.middlename,`phone_1`=c.phone,v.`fax`=c.fax,`address_1`=c.location,`address_2`=c.address,v.`city`=c.city,`virtuemart_state_id`=c.state,v.`state`=c.state,`virtuemart_country_id`=c.cb_select_country,`zip`=c.zipcode WHERE `virtuemart_user_id`='[user_id]';