String str = "select numero_devis as \"Numéro devis\", c.reference as \"Numero de contrat\", date_souscription as \"Date de souscription\", Date_devis as \"Date devis\", cad.reference as \" Numero de commande\", type as \"Type du produit\""+
" from persistent_object po, contrat c, contrat_assurance ca , caddie cad where"+
" po.id= c.id and po.historic_end_date is null and c.id=ca.id and c.caddie_fk=cad.id and Date_devis < '30/04/2008' and Date_devis > '20/04/2008' and type in ('DECES')";
List lst = session.createSQLQuery(str).list();
Partager