UPDATE according to select

Question

UPDATE according to select

Navigation

#1 by (0 votes)

0

SELECT
      t1.Descripcion,
      t1.IdReg,
      t2.IdReg As IdRegSegIncidente 
FROM 
     INCIDENTES t1
JOIN 
     (SELECT 
             IdRegIncidente,
             MAX(IdReg) IdReg 
      FROM 
             SEGUIMIENTO_INCIDENTES 
      GROUP BY 
             IdRegIncidente) t2
ON 
      t1.IdReg = t2.IdRegIncidente

The previous query returns the following table:

How can I use the previous query to update the SEGUIMIENTO_INCIDENTES table using the IdRegSegIncidente field?

sql-server

asked by José MN 19.04.2018 в 01:02

source

1 answer

Error with FullCalendar PHP Whitelabel Error Page

score 0 · Answer 1

Like this:

Update SEGUIMIENTO_INCIDENTES 
set SEGUIMIENTO_INCIDENTES.ColumnaActualizar = Valor
FROM 
     INCIDENTES t1
JOIN 
     (SELECT 
             IdRegIncidente,
             MAX(IdReg) IdReg 
      FROM 
             SEGUIMIENTO_INCIDENTES 
      GROUP BY 
             IdRegIncidente) t2
ON 
      t1.IdReg = t2.IdRegIncidente