Объединить 2 запроса в 1 таблицу

SELECT DISTINCT a.Equipment_Code, a.Equipment_Description, a.Source_MineArea, a.Source_Description, a.Operator_Description, a.Measure_Description, c.Shpur
FROM V_EQUIPMENTMEASURES 
a CROSS apply 
(SELECT b.MeasureValue AS Shpur FROM V_EQUIPMENTMEASURES b 
WHERE Period_Shift = N'Production Дневная смена 8 сентября 2021 г.' AND b.Status_Code = 'DRILLING' AND b.Measure_Code IN (N'45mmTOTAL','75mmTOTAL') AND b.equipment_code =a.equipment_code AND b.Measure_Description = a.Measure_Description) 
c WHERE a.Period_Shift = N'Production Дневная смена 8 сентября 2021 г.' AND a.Status_Code = 'DRILLING'

SELECT DISTINCT a.Equipment_Code,a.Source_MineArea, a.Source_Description, a.Operator_Description, a.Measure_Description, c.Meter
FROM V_EQUIPMENTMEASURES 
a CROSS apply (SELECT b.MeasureValue AS Meter FROM V_EQUIPMENTMEASURES b 
WHERE Period_Shift = N'Production Дневная смена 8 сентября 2021 г.' AND b.Status_Code = 'DRILLING' AND b.Measure_Code IN ('15MBY45MMHOLEDRILLED','26MBY45MMHOLEDRILLED','26MBY76MMHOLEDRILLED') AND b.equipment_code =a.equipment_code AND b.Measure_Description = a.Measure_Description) 
c WHERE a.Period_Shift = N'Production Дневная смена 8 сентября 2021 г.' AND a.Status_Code = 'DRILLING'