update auth_authorizations auths SET sycle_id =
(select patient_id
FROM s_patient WHERE
    s_patient.firstname = auths.f_name 
AND s_patient.lastname  = auths.l_name
) where exists
select patient_id
FROM s_patient WHERE
    s_patient.firstname = auths.f_name 
AND s_patient.lastname  = auths.l_name
)
[download]