UCU - Gestion » Backend ucugestion

UPDATE mesas_examenes
SET nroresolucion_equivalencia = folio
WHERE idcondicion = 5
  AND (nroresolucion_equivalencia IS NULL OR nroresolucion_equivalencia = '')
  AND folio IS NOT NULL AND folio <> '';

UPDATE alu_mat am
JOIN (
  SELECT idcatedra, MIN(idcomision) AS idcomision
  FROM comisiones
  GROUP BY idcatedra
) c ON c.idcatedra = am.idcatedra
SET am.idcomision = c.idcomision
WHERE am.idcomision = 0;