SELECT D.CodiceTipologiaEDOC, A.* FROM docum00f AS A JOIN ElencoDocumenti ON cnurc = idDocumento JOIN consolesdi AS D ON cnurc = id
WHERE ctipo = 'DES'
AND TipoDocumentoCollegato = 'PEC' AND CSTCO=''
AND IdCollegato IN
(

SELECT cnurc FROM docum00f JOIN ElencoDocumenti ON cnurc = idDocumento
WHERE ctipo = 'PEC'
AND TipoDocumentoCollegato = 'ALP'
AND IdCollegato IN (SELECT cnurc FROM docum00f WHERE ctipo='ALP' AND cchi1 IN('MC','RC')
))




UPDATE A SET ctipo = D.CodiceTipologiaEDOC
FROM docum00f AS A JOIN ElencoDocumenti ON cnurc = idDocumento JOIN consolesdi AS D ON cnurc = id
WHERE ctipo = 'DES'
AND TipoDocumentoCollegato = 'PEC' AND CSTCO=''
AND IdCollegato IN
(

SELECT cnurc FROM docum00f JOIN ElencoDocumenti ON cnurc = idDocumento
WHERE ctipo = 'PEC'
AND TipoDocumentoCollegato = 'ALP'
AND IdCollegato IN (SELECT cnurc FROM docum00f WHERE ctipo='ALP' AND cchi1 IN('MC','RC')
))