Untitled

SELECT * FROM DTL_VENTE JOIN DTL_FICHIER ON DTL_VENTE.ID_FICHIER = DTL_FICHIER.ID_FICHIER
WHERE TRUNC(DTHR_OPERATION) = '22/08/2024'
AND TYPE_EQUIPEMENT = 'MG'
AND NUM_EXPL_EQUIPEMENT = 121
AND (MNT_OPERATION = 500 OR MNT_OPERATION = 1000)
AND IND_ANNULATION = 0;