1 2 3 4 5 6 7 8 9
| SELECT DISTINCT Nom_Programme.IDNom_Programme AS IDNom_Programme,
Nom_Programme.Libélé_programme AS Lib_Programme
FROM PC, Designation, Versions_installées, Versions_existantes, Designation_version, Nom_Programme
WHERE PC.IDDesignation=Designation.IDDesignation
AND Designation.IDDesignation=Versions_installées.IDMachine
AND Versions_installées.IDVersions_existantes=Versions_existantes.IDVersions_existantes
AND Versions_existantes.IDDesignation_version=Designation_version.IDDesignation_version
AND Designation_version.IDNom_Programme=Nom_Programme.IDNom_Programme
AND PC.IDNomPC = {param1} |
Partager