SELECT 
	Fournisseur.Nom_Frs AS Nom,	
	Fournisseur.Commantaire_frs AS Commantaire,	
	Fournisseur.SIREN_frs AS SIREN,	
	Ville.Nom_ville AS ville,	
	Ville.code_postal AS cp,	
	Ville.Adresse AS Adresse,	
	Ville.Pays AS Pays,	
	Contact_Prest.Nom_contact AS Nomcontact,	
	Contact_Prest.Prenom_contact AS Prenomcontact,	
	Contact_Prest.E_mail_contact AS Emailcontact,	
	Contact_Prest.Fax_contact AS Faxcontact,	
	Contact_Prest.Tel_contact AS Telcontact,	
	Contact_Prest.Commentaire_prest AS Commentaireprest,
        Contact_Prest.Ville AS Ville_Prest
FROM 
	Ville,	
	Fournisseur,	
	Contact_Prest
WHERE 
		Ville.IDVille = Fournisseur.IDVille
	AND	Contact_Prest.IDFournisseur = Fournisseur.IDFournisseur 
        AND     Ville.IDVille = Contact_Prest.IDVille