Сбор в один столбец запроса данных из столбцов 2-х разных таблиц.

SELECT `glpi_tickets`.`id` AS ticket_id , 
    `glpi_tickets`.`name` AS title , 
    `glpi_tickets`.`status` AS STATUS, 
    `glpi_tickets`.`itemtype` AS itemtype, 
    `glpi_entities`.`name` AS entity, 
    `glpi_locations`.`name` AS location
FROM glpi_tickets 
LEFT JOIN `glpi_computers` ON (`glpi_tickets`.`items_id` =`glpi_computers`.`id`)
LEFT JOIN `glpi_printers` ON (`glpi_tickets`.`items_id` =`glpi_printers`.`id`)  
LEFT JOIN `glpi_entities` ON (`glpi_tickets`.`entities_id` =`glpi_entities`.`id`) 
LEFT JOIN `glpi_locations` ON (`glpi_computers`.`locations_id` =`glpi_locations`.`id`) OR (`glpi_printers`.`locations_id` =`glpi_locations`.`id`)
WHERE `glpi_tickets`.`id`<>0

SELECT `glpi_tickets`.`id` AS ticket_id , 
    `glpi_tickets`.`name` AS title , 
    `glpi_tickets`.`status` AS STATUS, 
    `glpi_tickets`.`itemtype` AS itemtype,
    `glpi_computers`.`name` AS name,
    `glpi_entities`.`name` AS entity, 
    `glpi_locations`.`name` AS location
FROM glpi_tickets 
JOIN `glpi_computers` ON (`glpi_tickets`.`items_id` =`glpi_computers`.`id`)
LEFT JOIN `glpi_entities` ON (`glpi_tickets`.`entities_id` =`glpi_entities`.`id`) 
LEFT JOIN `glpi_locations` ON (`glpi_computers`.`locations_id` =`glpi_locations`.`id`)
WHERE `glpi_tickets`.`itemtype`= "Computer"
UNION
SELECT `glpi_tickets`.`id` AS ticket_id , 
    `glpi_tickets`.`name` AS title , 
    `glpi_tickets`.`status` AS STATUS, 
    `glpi_tickets`.`itemtype` AS itemtype,
    `glpi_printers`.`name` AS name,
    `glpi_entities`.`name` AS entity, 
    `glpi_locations`.`name` AS location
FROM glpi_tickets 
JOIN `glpi_printers` ON (`glpi_tickets`.`items_id` =`glpi_printers`.`id`)
LEFT JOIN `glpi_entities` ON (`glpi_tickets`.`entities_id` =`glpi_entities`.`id`) 
LEFT JOIN `glpi_locations` ON (`glpi_printers`.`locations_id` =`glpi_locations`.`id`)
WHERE `glpi_tickets`.`itemtype`= "Printer"

SELECT `glpi_tickets`.`id` AS ticket_id , 
    `glpi_tickets`.`name` AS title , 
    `glpi_tickets`.`status` AS STATUS, 
    `glpi_tickets`.`itemtype` AS itemtype,
    `glpi_printers`.`name` AS name,
        `glpi_computers`.`name` AS name,  
    `glpi_entities`.`name` AS entity, 
    `glpi_locations`.`name` AS location
FROM glpi_tickets 
LEFT JOIN `glpi_computers` ON (`glpi_tickets`.`items_id` =`glpi_computers`.`id`)
LEFT JOIN `glpi_printers` ON (`glpi_tickets`.`items_id` =`glpi_printers`.`id`)  
LEFT JOIN `glpi_entities` ON (`glpi_tickets`.`entities_id` =`glpi_entities`.`id`) 
LEFT JOIN `glpi_locations` ON (`glpi_computers`.`locations_id` =`glpi_locations`.`id`) OR (`glpi_printers`.`locations_id` =`glpi_locations`.`id`)
WHERE `glpi_tickets`.`id`<>0

--создали переменную
DECLARE @name_table TABLE
(
    first_feald INT,
    second_feald VARCHAR(20)
)
 
--вставили данные из первой таблицы
INSERT INTO @name_table (first_feald , second_feald)
SELECT ddd AS first_feald,
       ccc AS second_feald
FROM firstTable
 
--вставили данные из второй таблицы
INSERT INTO @name_table (first_feald , second_feald)
SELECT ddd AS first_feald,
       ccc AS second_feald
FROM secondTable
 
--вывели результат
SELECT @name_table

SELECT * FROM @name_table

SELECT `glpi_tickets`.`id` AS ticket_id, 
`glpi_tickets`.`name` AS title , 
`glpi_tickets`.`itemtype` AS itemtype, 
`glpi_entities`.`name` AS entity, 
`glpi_locations`.`name` AS location, 
CASE `glpi_tickets`.`status` 
WHEN "new" THEN "новая" 
WHEN "assign" THEN "принята" 
WHEN "plan" THEN "запланирована" 
WHEN "waiting" THEN "решается" 
WHEN "solved" THEN "решена" 
WHEN "closed" THEN "закрыта" 
ELSE "unknown" 
END AS STATUS, 
CASE `glpi_tickets`.`itemtype`
WHEN "Printer" THEN `glpi_printers`.`name`
 WHEN "Computer" THEN `glpi_computers`.`name`
 WHEN "Monitor" THEN `glpi_monitors`.`name` 
WHEN "NetworkEquipment" THEN `glpi_networkequipments`.`name` 
ELSE "unknown" 
END AS name 
FROM glpi_tickets 
LEFT JOIN `glpi_printers` ON (`glpi_tickets`.`items_id` =`glpi_printers`.`id`) 
LEFT JOIN `glpi_computers` ON (`glpi_tickets`.`items_id` =`glpi_computers`.`id`) 
LEFT JOIN `glpi_monitors` ON (`glpi_tickets`.`items_id` =`glpi_monitors`.`id`) 
LEFT JOIN `glpi_networkequipments` ON (`glpi_tickets`.`items_id` =`glpi_networkequipments`.`id`) 
LEFT JOIN `glpi_locations` ON (`glpi_printers`.`locations_id` =`glpi_locations`.`id`) OR (`glpi_computers`.`locations_id` =`glpi_locations`.`id`) OR (`glpi_monitors`.`locations_id` =`glpi_locations`.`id`) OR (`glpi_networkequipments`.`locations_id` =`glpi_locations`.`id`) 
LEFT JOIN `glpi_entities` ON (`glpi_tickets`.`entities_id` =`glpi_entities`.`id`)
WHERE `glpi_tickets`.`id`<>0