MySQL 5.6

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

CREATE TABLE Table1 (
  `ID1` VARCHAR(3),
  `Date1` DATETIME,
  `Value1` INTEGER
);

INSERT INTO Table1
  (`ID1`, `Date1`, `Value1`)
VALUES
  ('T-1', '2019-12-15 12:14:13', '10000'),
  ('T-2', '2019-12-15 16:17:24', '11000'),
  ('T-3', '2019-12-17 10:01:11', '15000'),
  ('T-4', '2019-12-18 21:10:21', '17000');

CREATE TABLE Table2 (
  `ID2` VARCHAR(3),
  `Date2` DATETIME,
  `Value2` INTEGER,
  `Seq` INTEGER
);

INSERT INTO Table2
  (`ID2`, `Date2`, `Value2`, `Seq`)
VALUES
  ('T-1', '2019-12-16 19:18:11', '10000', '1'),
  ('T-2', '2019-12-16 16:33:24', '12000', '1'),
  ('T-2', '2019-12-17 15:21:21', '12000', '2'),
  ('T-2', '2019-12-17 13:10:18', '18000', '3'),
  ('T-2', '2019-12-18 19:18:07', '11000', '4'),
  ('T-3', '2019-12-17 11:11:11', '14000', '1'),
  ('T-3', '2019-12-18 22:18:08', '13000', '2'),
  ('T-3', '2019-12-18 19:07:01', '13000', '3'),
  ('T-4', '2019-12-19 21:38:15', '17000', '1'),
  ('T-4', '2019-12-19 21:45:20', '17000', '2');

CREATE TABLE Table3 (
  `ID3` VARCHAR(3),
  `Date3` DATETIME,
  `Value3` INTEGER
);

INSERT INTO Table3
  (`ID3`, `Date3`, `Value3`)
VALUES
  ('T-1', '2019-12-16 19:18:11', '10000'),
  ('T-2', '2019-12-18 19:18:07', '11000'),
  ('T-3', '2019-12-18 19:07:01', '13000'),
  ('T-4', '2019-12-19 21:45:20', '17000');
select t3.ID3, t1.Value1, t2.Value2, 
  t2.Date2 As Initial_Date, t3.Date3 As Final_Date, 
  t1.Value1 = t2.Value2 Status
from Table1 t1
Left Join Table2 t2 on t1.ID1=t2.ID2
Left Join Table3 t3 on t2.ID2=t3.ID3
where t2.Seq = 1


ID3
Value1
Value2
Initial_Date
Final_Date
Status


T-1
10000
10000
2019-12-16 19:18:11
2019-12-16 19:18:11
1

T-2
11000
12000
2019-12-16 16:33:24
2019-12-18 19:18:07
0

T-3
15000
14000
2019-12-17 11:11:11
2019-12-18 19:07:01
0

T-4
17000
17000
2019-12-19 21:38:15
2019-12-19 21:45:20
1


select t3.ID3, t1.Value1, t2.Value2, 
  t2.Date2 As Initial_Date, t3.Date3 As Final_Date, 
  case when t1.Value1 = t2.Value2 then 'TRUE' else 'FALSE' end Status
from Table1 t1
Left Join Table2 t2 on t1.ID1=t2.ID2
Left Join Table3 t3 on t2.ID2=t3.ID3
where t2.Seq = 1


ID3
Value1
Value2
Initial_Date
Final_Date
Status


T-1
10000
10000
2019-12-16 19:18:11
2019-12-16 19:18:11
TRUE

T-2
11000
12000
2019-12-16 16:33:24
2019-12-18 19:18:07
FALSE

T-3
15000
14000
2019-12-17 11:11:11
2019-12-18 19:07:01
FALSE

T-4
17000
17000
2019-12-19 21:38:15
2019-12-19 21:45:20
TRUE

ID3	Value1	Value2	Initial_Date	Final_Date	Status
T-1	10000	10000	2019-12-16 19:18:11	2019-12-16 19:18:11	1
T-2	11000	12000	2019-12-16 16:33:24	2019-12-18 19:18:07	0
T-3	15000	14000	2019-12-17 11:11:11	2019-12-18 19:07:01	0
T-4	17000	17000	2019-12-19 21:38:15	2019-12-19 21:45:20	1