AS users_id, glpi_tickets.priority, glpi_itilcategories.completenameglpi_tickets.users_id_lastupdater = glpi_users.id THEN
CONCAT(glpi_users.firstname, ' ',<
我有8个表,其中包含计算机外围设备不同特定值,它们是glpi_device_ram、glpi_device_hdd、glpi_device_gfxcard、glpi_device_sndcard。glpi_device_hdd"
WHEN "5" THEN "glpi_device_iface"WHEN "6" THEN "glpi_dev
INNER JOIN glpi_infocoms ON glpi_peripherals.id = glpi_infocoms.items_id WHERE glpi_infocoms.items_idJOIN glpi_infocoms ON glpi_computers.id = glpi_infocoms.items_id WHERE glpi_infocoms.items_id = $infocomJOIN glpi_info