SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
drop table if exists #Table_A
drop table if exists #Table_B
drop table if exists #Table_C

create table #Table_A
(
    [DATE] Date,
    TYPE    INT,
    QTY     INT
);

create table #Table_B
(
    [DATE] Date,
    TYPE    INT,
    QTY     INT
);

create table #Table_C
(
    [DATE] Date,
    TYPE    INT,
    QTY     INT
);

Insert into #Table_A VALUES ('2018-01-01', 1, 10)
Insert into #Table_B VALUES ('2018-01-01', 1, 5)
Insert into #Table_B VALUES ('2018-01-01', 2, 10)
Insert into #Table_B VALUES ('2018-01-01', 3, 10)
Insert into #Table_C VALUES ('2018-01-01', 1, 5)
Insert into #Table_C VALUES ('2018-01-01', 2, 10)
Insert into #Table_C VALUES ('2018-01-01', 3, 10)
7 rows affected

select 
    A.[DATE], 
    SUM(CASE WHEN A.[TYPE] = 1 THEN A.QTY END)  A_QTY,
    SUM(CASE WHEN B.[TYPE] = 1 THEN B.QTY END)  B_QTY,
    SUM(CASE WHEN C.[TYPE] = 1 THEN C.QTY END)  C_QTY,
    SUM(CASE WHEN A.[TYPE] = 2 THEN A.QTY END)  A_QTY,
    SUM(CASE WHEN B.[TYPE] = 2 THEN B.QTY END)  B_QTY,
    SUM(CASE WHEN C.[TYPE] = 2 THEN C.QTY END)  C_QTY,
    SUM(CASE WHEN A.[TYPE] = 3 THEN A.QTY END)  A_QTY,
    SUM(CASE WHEN B.[TYPE] = 3 THEN B.QTY END)  B_QTY,
    SUM(CASE WHEN C.[TYPE] = 3 THEN C.QTY END)  C_QTY
FROM 
    #Table_A A 
    INNER JOIN #Table_B B ON A.DATE = B.DATE AND A.TYPE = B.TYPE
    INNER JOIN #Table_C C ON A.DATE = C.DATE AND A.TYPE = C.TYPE
GROUP BY A.[DATE]


DATE
A_QTY
B_QTY
C_QTY
A_QTY
B_QTY
C_QTY
A_QTY
B_QTY
C_QTY


01/01/2018 00:00:00
10
5
5
null
null
null
null
null
null


Warning: Null value is eliminated by an aggregate or other SET operation.


select 
    COALESCE(A.[DATE], B.[DATE], C.[DATE]) DATE,
    SUM(CASE WHEN A.[TYPE] = 1 THEN A.QTY END)  A_QTY,
    SUM(CASE WHEN B.[TYPE] = 1 THEN B.QTY END)  B_QTY,
    SUM(CASE WHEN C.[TYPE] = 1 THEN C.QTY END)  C_QTY,
    SUM(CASE WHEN A.[TYPE] = 2 THEN A.QTY END)  A_QTY,
    SUM(CASE WHEN B.[TYPE] = 2 THEN B.QTY END)  B_QTY,
    SUM(CASE WHEN C.[TYPE] = 2 THEN C.QTY END)  C_QTY,
    SUM(CASE WHEN A.[TYPE] = 3 THEN A.QTY END)  A_QTY,
    SUM(CASE WHEN B.[TYPE] = 3 THEN B.QTY END)  B_QTY,
    SUM(CASE WHEN C.[TYPE] = 3 THEN C.QTY END)  C_QTY
FROM 
    #Table_A A 
    FULL OUTER JOIN #Table_B B ON A.DATE = B.DATE AND A.TYPE = B.TYPE
    FULL OUTER JOIN #Table_C C ON A.DATE = C.DATE AND A.TYPE = C.TYPE
GROUP BY COALESCE(A.[DATE], B.[DATE], C.[DATE])


DATE
A_QTY
B_QTY
C_QTY
A_QTY
B_QTY
C_QTY
A_QTY
B_QTY
C_QTY


01/01/2018 00:00:00
10
5
5
null
10
10
null
10
10


Warning: Null value is eliminated by an aggregate or other SET operation.