Now i'm going to extract this data with SYLK export feature, but... why
this query (MySQL 4.1) return only 71 record over 119?
SELECT glpi_computers.ID, glpi_computers.name, glpi_computers.serial,
glpi_computers.otherserial, glpi_computers.contact,
glpi_computers.contact_num, glpi_infocoms.buy_date,
glpi_infocoms.use_date, glpi_infocoms.warranty_duration,
glpi_infocoms.num_commande, glpi_infocoms.bon_livraison,
glpi_infocoms.num_immo
FROM glpi_computers LEFT JOIN glpi_infocoms
ON glpi_computers.ID = glpi_infocoms.FK_device
WHERE ((glpi_infocoms.device_type=1) OR (glpi_infocoms.device_type is NULL))
ORDER BY glpi_computers.ID;
What i'm missing?
--
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bont�, 7 - 33078 - San Vito al Tagliamento (PN)
marco.gaiarin(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797
_______________________________________________
Glpi-dev mailing list
[email protected]
https://mail.gna.org/listinfo/glpi-dev
