SELECT d.id,p.codePrestataire,p.libelle,a.codeGarantie,a.codeFamilleActe,a.codeActe,a.libelle,a.lettreCle,a.coefficient,d.prix,d.prixNuitFerier 
FROM p_detailtarifacteprestataire d
INNER JOIN prestataire p ON (p.codePrestataire=d.codePrestataire)
INNER JOIN p_acte a ON (a.codeActe=d.codeActe)
ORDER BY codePrestataire,codeGarantie,codeActe




SELECT d.id,p.codePrestataire,p.libelle,d.lettreCle,d.cout,d.coutNuit
FROM prestataire_lettre_cle d
INNER JOIN prestataire p ON (p.codePrestataire=d.codePrestataire)
WHERE d.lettreCle IN ('B','Z')
-- INNER JOIN p_acte a ON (a.codeActe=d.codeActe)
ORDER BY codePrestataire
 
SELECT * FROM prestataire_lettre_cle WHERE codePrestataire='CE1239'

SELECT d.id,p.codePrestataire,p.libelle,o.id,o.libellePolice
,a.codeGarantie,a.codeFamilleActe,a.codeActe,a.libelle,a.lettreCle,a.coefficient,d.prix,d.prixNuitFerier 
FROM p_detailtarifactepoliceprestataire d
INNER JOIN prestataire p ON (p.codePrestataire=d.codePrestataire)
INNER JOIN p_acte a ON (a.codeActe=d.codeActe)
INNER JOIN police o ON (o.id=d.idPolice)
ORDER BY codePrestataire,o.id,codeGarantie,codeActe


SELECT * FROM police

SELECT * FROM `vw_p_tarif_acte`
WHERE codeGarantie IN ('BIO','IMA')


``
			WHERE (codeTarifActe=@codeTarifActePolice) 
			AND (codeActe=p_codeActe) 
			AND (idPolice=p_idPolice)
			AND (codePrestataire=p_codePrestataire)
