1 2 3 4 5 6 7 8 9 10 11 12 13 14
| SELECT ouapi_ha_marque.libelle, num_serie, ouapi_ha_modele.libelle, ouapi_ha_type.libelle, ouapi_hardware.nom,
ouapi_ha_os.libelle, ouapi_utilisateur.prenom, ouapi_utilisateur.nom, ouapi_emplacement.libelle, ouapi_hardware.ip,
ouapi_hardware.reservable, ouapi_hardware.commentaire, ouapi_hardware.pfield_nommachine, ouapi_hardware.pfield_datedachat,
ouapi_hardware.pfield_ncommande, ouapi_hardware.pfield_imputation, ouapi_hardware.pfield_numemn, ouapi_hardware.pfield_adressemac, ouapi_hardware.pfield_numsav
FROM ouapi_hardware
left JOIN ouapi_ha_marque ON ouapi_ha_marque.id = ouapi_hardware.marque_id
left JOIN ouapi_ha_modele ON ouapi_ha_modele.id = ouapi_hardware.modele_id
left JOIN ouapi_ha_type ON ouapi_ha_type.id = ouapi_hardware.type_id
left JOIN ouapi_ha_os ON ouapi_ha_os.id = ouapi_hardware.os_id
left JOIN ouapi_emplacement ON ouapi_emplacement.id = ouapi_hardware.emplacement_id
INNER JOIN ouapi_utilisateur ON ouapi_utilisateur.id = ouapi_hardware.user_id
WHERE ouapi_utilisateur.nom = 'Laine'
OR ouapi_utilisateur.prenom = 'Laine' |
Partager