SQL |
SELECT DISTINCT AF_ID, DENOM_CON_IT, DOC_RESP_DID_ID_IT, COGNOME_RESP_DID_IT, NOME_RESP_DID_IT, CDS_COD_IT, AA_OFF_ID, AF_GEN_COD_IT, ANNO_CORSO_IT, CICLO_DES_IT, PERCORSO
,DENOM_CON_EN
FROM TB_SCHEDA_INSEGNAMENTO
WHERE
1=1
AND CDS_COD_IT = '0792'
AND DIP_ID = '21954'
AND AA_OFF_ID = '2020'
ORDER BY DENOM_CON_IT ASC |