SQL Server 2014

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table Table1 (DATE1 date, RM int);

INSERT INTO Table1 VALUES ('1/4/2020' , 1);
INSERT INTO Table1 VALUES ('2/1/2020' , 4);
INSERT INTO Table1 VALUES ('2/10/2020' , 4);

3 rows affected

create table Table2 (DATE2 date, KM int);

INSERT INTO Table2 VALUES ('2/2/2020' , 1);
INSERT INTO Table2 VALUES ('2/10/2020' , 3);
INSERT INTO Table2 VALUES ('3/5/2020' , 2);
3 rows affected

select * from Table1;


DATE1
RM


2020-01-04
1

2020-02-01
4

2020-02-10
4


select * from Table2;


DATE2
KM


2020-02-02
1

2020-02-10
3

2020-03-05
2


SELECT isnull(date1,date2) as Date3, ISNULL(RM, 0 ),ISNULL(KM, 0 )
FROM table1 
FULL JOIN table2 
ON table1.Date1 = table2.Date2
order by Date3;


Date3
(No column name)
(No column name)


2020-01-04
1
0

2020-02-01
4
0

2020-02-02
0
1

2020-02-10
4
3

2020-03-05
0
2

Date3	(No column name)	(No column name)
2020-01-04	1	0
2020-02-01	4	0
2020-02-02	0	1
2020-02-10	4	3
2020-03-05	0	2