CREATE TABLE infosvm
AS SELECT idvm, nomvm, description, tailledd, memoireram, typestockage, nomdepartement, nomdemandeur, prenomdemandeur
FROM vm v
join demandeur dem on dem.iddemandeur = v.iddemandeur
join departement dep on dep.iddepartement = v.iddepartement;