SELECT T_chambres.num_chambre, T_chambres.[#cité], T_chambres.numéro, T_chambres.type, T_chambres.places, T_chambres.surface, T_chambres.sanitaires, T_places.num_place, T_places.[#chambre], T_places.Type_lit, T_occupations.num_occupation, T_occupations.[#etudiant], T_occupations.[#place], T_occupations.Date_contrat, T_occupations.Date_début, T_occupations.Date_fin, T_etudiants.Genre
FROM (T_chambres INNER JOIN T_places ON T_chambres.[num_chambre] = T_places.[#chambre]) INNER JOIN (T_etudiants INNER JOIN T_occupations ON T_etudiants.[Num_etudiant] = T_occupations.[#etudiant]) ON T_places.[num_place] = T_occupations.[#place];
Partager