SQL Server 2017

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

CREATE TABLE person (
  ID INT
);
INSERT INTO person VALUES (1);
1 rows affected

CREATE TABLE events (
  ID INT,
  [date] DATE
);
INSERT INTO events VALUES
  (1, '2019-01-01'),
  (2, '2019-02-01'),
  (3, '2019-03-01');
3 rows affected

CREATE TABLE tickets (
  event_id INT,
  person_id INT
);
INSERT INTO tickets VALUES
  (1, 1),
  (2, 1),
  (3, 1);
3 rows affected

SELECT p.ID, e.ID, e.date 
FROM tickets t 
   INNER JOIN person p ON t.person_id = p.ID 
   INNER JOIN events e ON t.event_id = e.ID
WHERE p.ID = 1


ID
ID
date


1
1
01/01/2019 00:00:00

1
2
01/02/2019 00:00:00

1
3
01/03/2019 00:00:00

ID	ID	date
1	1	01/01/2019 00:00:00
1	2	01/02/2019 00:00:00
1	3	01/03/2019 00:00:00