sqlserver 怎么实现多表

sqlserver 怎么将两个查询的子表合并成一个新表
这是第一张表


SELECT --乙碳产品
    case when INPUT_TAG ='乙碳日报' then '乙碳车间' end INPUT_TAG,
    INPUT_TAG2,
    INPUT_TAG3,
    sum( CAST(INPUT_VALUE as FLOAT) ) INPUT_VALUE
FROM
    RP_INPUT_VALUES_YT a,
    (
    SELECT
        b.START_DATE,
        b.END_DATE 
    FROM
        TEAM_WORK_CALENDARS a,
        TEAM_MONTH_CALENDARS b,
        RP_REPORTS c 
    WHERE
        a.ID = b.WORK_CALENDAR 
        AND YEAR('2023-07-15')=YEAR(END_DATE) 
        AND c.ID = '1066' 
        AND c.WORKCALENDAR_ID = a.ID 
    ) b 
WHERE
    INPUT_DATE BETWEEN b.START_DATE 
    AND  b.END_DATE 
    AND INPUT_VALUE !=''
    and INPUT_VALUE not like '%[吖-座-a-z]%'
AND VALID=1
and (INPUT_TAG3='今日产量' or INPUT_TAG3='今日累计')
and (INPUT_TAG2='电池级乙碳B' 
or INPUT_TAG2='工业一级乙碳总量' )
 GROUP BY
        INPUT_TAG,
    INPUT_TAG2,
    INPUT_TAG3

img

这是第二张表

SELECT--新材料产品
CASE
        
        WHEN INPUT_TAG = '新材料日报' THEN
        '新材料车间' 
    END INPUT_TAG,
    INPUT_TAG2,
    INPUT_TAG3,
    INPUT_TAG4,
    SUM ( CAST ( INPUT_VALUE AS FLOAT ) ) INPUT_VALUE 
FROM
    RP_INPUT_VALUES_XCL a,
    (
    SELECT
        b.START_DATE,
        b.END_DATE 
    FROM
        TEAM_WORK_CALENDARS a,
        TEAM_MONTH_CALENDARS b,
        RP_REPORTS c 
    WHERE
        a.ID = b.WORK_CALENDAR 
        AND YEAR ( '2023-07-15' ) = YEAR ( END_DATE ) 
        AND c.ID = '1066' 
        AND c.WORKCALENDAR_ID = a.ID 
    ) b 
WHERE
    INPUT_DATE BETWEEN b.START_DATE 
    AND b.END_DATE 
    AND INPUT_VALUE != '' 
    AND INPUT_VALUE NOT LIKE '%[吖-座-a-z]%' 
    AND VALID = 1 
    AND ( INPUT_TAG3 = '产品EMC' OR INPUT_TAG3 = '产品DMC' ) 
    AND ( INPUT_TAG2 = '二+三万吨装置' OR INPUT_TAG2 = '五万吨装置' ) 
    AND INPUT_TAG4 = '当日产量' 
GROUP BY
    INPUT_TAG,
    INPUT_TAG2,
    INPUT_TAG3,
    INPUT_TAG4

img

该怎么做才能实现下面的效果，请求各位大佬帮帮孩子

img

用union联合啊；然后两张表的字段必须一模一样，你第一个少了个tag4，要把tag4加上