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
FROM 
	Ville,	
	Fournisseur,	
	Contact_Prest
WHERE 
		Ville.IDVille = Fournisseur.IDVille
	AND	Contact_Prest.IDFournisseur = Fournisseur.IDFournisseur