SELECT t.id,t.codeTypeGarant,t.libelle AS TypeGarant,
g.codeGcAssureur,g.libelle AS Garant,
p.id,p.numeroPolice,p.numeroPoliceGarant,p.libellePolice,p.dateEffet,p.dateFin,p.dateEcheance,p.codeApporteur
,p.tauxCommissionGerant,p.tauxCommissionGcAssureur,p.rembourserA,p.dernierNumeroAdherent
FROM gc_assureur g 
INNER JOIN gc_typegarant t ON (g.typeGarant=t.id) 
INNER JOIN police p ON ((p.codeGcAssureur=g.codeGcAssureur) AND (p.codeSociete=g.codeSociete) )
 WHERE g.codeGcAssureur='ALLIANZCI'

ORDER BY t.id,g.codeGcAssureur,p.id


/*SELECT * FROM police
ORDER BY numeroPolice*/