UPDATE cscart_profile_fields.value SET cscart_profile_fields_data.value = '0' FROM cscart_profile_fields_data INNER JOIN ...
stackoverflow.com