...but i think i've found the clue. The condition (glpi_infocoms.device_type=1) that select computers came after th LEFT JOIN clause, and so i have three types of records:
You need add it on the ON clause. It is a condition for the left join.
Please, can the device_type field also be added to computers (and clearly monitors, printers, ...) table? Clearly it is fully redundant, but will help in query like these. ;)
Why add redundant information ? This will not solved your problem. All device type are constants so we do not need to add them on tables. Julien _______________________________________________ Glpi-dev mailing list Glpi-dev@gna.org https://mail.gna.org/listinfo/glpi-dev
