requete

select * from v_mogec_ic_with_historic
INNER JOIN t_dernieres_validations on v_mogec_ic_with_historic.crdserial = t_dernieres_validations.num_serie
where t_dernieres_validations.code_produit = 204 AND t_dernieres_validations.date_validation between '15/10/2019' AND '21/10/2019';