1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
|
SELECT
T_Valise.ID_Valise,
T_Valise.NomPC,
T_Valise.Version_IDS,
T_Valise.VersionStartIDS,
T_Valise.NumTeamViewer,
T_Valise.DateEnvoieValise,
T_Valise.DateFinMaintenanceSoft,
T_Valise.DateFinMaintenanceHard,
T_UsersValise.Responsable,
T_OS.OS,
T_Valise.NumLicenceWindows,
T_TypeValise.Type,
T_Valise.Scanner,
T_TypeConnexion.TypeConnexion,
T_Aeroport.Code,
T_Villes.Ville,
T_Pays.Nom,
T_Valise.NumSerieScan,
T_Valise.VersionSDK
FROM
T_Valise LEFT OUTER JOIN T_UsersValise ON T_Valise.ID_UsersValise = T_UsersValise.ID_UsersValise,
T_Valise LEFT OUTER JOIN T_OS ON T_Valise.ID_OS = T_OS.ID_OS,
T_Valise LEFT OUTER JOIN T_TypeValise ON T_Valise.TypeValise = T_TypeValise.ID_TypeValise,
T_Valise LEFT OUTER JOIN T_TypeConnexion ON T_Valise.ID_TypeConnexion = T_TypeConnexion.ID_TypeConnexion,
T_UsersValise LEFT OUTER JOIN T_Aeroport ON T_UsersValise.Aéroport = T_Aeroport.ID_Aeroport,
T_Aeroport LEFT OUTER JOIN T_Villes ON T_Aeroport.Ville = T_Villes.ID_Villes,
T_Aeroport LEFT OUTER JOIN T_Pays ON T_Aeroport.Pays = T_Pays.ID_Pays
WHERE
(
T_Valise.NomPC LIKE %{ParamFiltre}%
OR T_UsersValise.Responsable LIKE %{ParamFiltre}%
OR T_TypeValise.Type LIKE %{ParamFiltre}%
OR T_Valise.Scanner LIKE %{ParamFiltre}%
OR T_OS.OS LIKE %{ParamFiltre}%
)
ORDER BY
T_Valise.NomPC ASC |
Partager