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;
Leave a Comment