MySQL 8.0

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

CREATE TABLE t2
AS
          SELECT '01.01.2020' `Date`, 	'Type 1'  Types, 	1 Report_ID, 	'Name 1' Name
UNION ALL SELECT '01.01.2020' 	    ,    'Type 1' ,	2, 	'Name 2'
UNION ALL SELECT '01.01.2020' 	    ,    'Type 3' ,	3, 	'Name 3'
CREATE TABLE t1
AS
          SELECT 1  AS Report_ID	 ,'Name 1' 	,'Value 1' Value
UNION ALL SELECT 2 	                 ,'Name 2'	,'Value 2'
UNION ALL SELECT 3 	                 ,'Name 3' 	,'Value 3'
WITH cte AS (
  SELECT t2.*, t1.Value, ROW_NUMBER() OVER(PARTITION BY `Date`, Types ORDER BY Report_ID DESC) AS rn
  FROM t2
  JOIN t1 ON t1.Report_ID = t2.Report_ID
)
SELECT * FROM cte WHERE rn = 1;


Date
Types
Report_ID
Name
Value
rn


01.01.2020
Type 1
2
Name 2
Value 2
1

01.01.2020
Type 3
3
Name 3
Value 3
1

Date	Types	Report_ID	Name	Value	rn
01.01.2020	Type 1	2	Name 2	Value 2	1
01.01.2020	Type 3	3	Name 3	Value 3	1