UPDATE camp
SET camp.CAMP_Validaciones = NULL
FROM TESISSEG.dbo.AS_CAMPOS  camp
         INNER JOIN TESISSEG.dbo.AS_FORMCAMP  campform
                    ON campform.CAMP_Id  = camp.CAMP_Id AND campform.EmpID = camp.EmpID
         INNER JOIN TESISSEG.dbo.AS_FORMS  form
                    ON form.FORM_Id  = campform.FORM_Id  AND form.EmpID = camp.EmpID

WHERE camp.CAMP_Nombre  NOT IN( 'anio_construccion', 'direccion', 'cp', 'poblacion') AND form.FORM_Nombre = 'Hogar'



UPDATE camp
SET camp.CAMP_Validaciones = NULL
FROM TESISSEG.dbo.AS_CAMPOS  camp
         INNER JOIN TESISSEG.dbo.AS_FORMCAMP  campform
                    ON campform.CAMP_Id  = camp.CAMP_Id AND campform.EmpID = camp.EmpID
         INNER JOIN TESISSEG.dbo.AS_FORMS  form
                    ON form.FORM_Id  = campform.FORM_Id  AND form.EmpID = camp.EmpID

WHERE camp.CAMP_Nombre NOT IN( 'marca', 'modelo', 'matricula') AND form.FORM_Nombre = 'Autos'