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 = '0738'
AND DIP_ID = '21944'
AND AA_OFF_ID = '2021'
ORDER BY DENOM_CON_IT ASC |