SQLite 3.39

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

CREATE TABLE A (`tournament` INTEGER, `year` INTEGER, `course` INTEGER, `round` INTEGER, `hole` INTEGER, `front` INTEGER, `side` INTEGER, `region` INTEGER);
✓
INSERT INTO A (`tournament`, `year`, `course`, `round`, `hole`, `front`, `side`, `region`) VALUES
  ('33', '2016', '895', '1', '1', '12', '5', 'L'),
  ('33', '2016', '895', '1', '2', '18', '10', 'R'),
  ('33', '2016', '895', '1', '3', '15', '7', 'R'),
  ('33', '2016', '895', '1', '4', '11', '7', 'R'),
  ('33', '2016', '895', '1', '5', '18', '7', 'L'),
  ('33', '2016', '895', '1', '6', '28', '5', 'L'),
  ('33', '2016', '895', '1', '7', '21', '12', 'R'),
  ('33', '2016', '895', '1', '8', '14', '4', 'L'),
  ('33', '2016', '895', '1', '9', '10', '5', 'R'),
  ('33', '2016', '895', '1', '10', '11', '4', 'R'),
  ('33', '2016', '880', '1', '1', '12', '5', 'L'),
  ('33', '2016', '880', '1', '2', '18', '10', 'R'),
  ('33', '2016', '880', '1', '3', '15', '7', 'R'),
  ('33', '2016', '880', '1', '4', '11', '7', 'R'),
  ('33', '2016', '880', '1', '5', '18', '7', 'L'),
  ('33', '2016', '880', '1', '6', '28', '5', 'L'),
  ('33', '2016', '880', '1', '7', '21', '12', 'R'),
  ('33', '2016', '880', '1', '8', '14', '4', 'L'),
  ('33', '2016', '880', '1', '9', '10', '5', 'R'),
  ('33', '2016', '880', '1', '10', '11', '4', 'R'),
  ('33', '2016', '715', '1', '1', '12', '5', 'L'),
  ('33', '2016', '715', '1', '2', '18', '10', 'R'),
  ('33', '2016', '715', '1', '3', '15', '7', 'R'),
  ('33', '2016', '715', '1', '4', '11', '7', 'R'),
  ('33', '2016', '715', '1', '5', '18', '7', 'L'),
  ('33', '2016', '715', '1', '6', '28', '5', 'L'),
  ('33', '2016', '715', '1', '7', '21', '12', 'R'),
  ('33', '2016', '715', '1', '8', '14', '4', 'L'),
  ('33', '2016', '715', '1', '9', '10', '5', 'R'),
  ('33', '2016', '715', '1', '10', '11', '4', 'R');
✓
CREATE TABLE B (`tournament` INTEGER, `year` INTEGER, `R1` INTEGER, `R2` INTEGER, `R3` INTEGER, `R4` INTEGER);
✓
INSERT INTO B VALUES
  (33, 2016, 715, 715, 715, 715);
✓
DELETE FROM A
WHERE NOT EXISTS (
  SELECT *
  FROM B
  WHERE A.course IN (B.R1, B.R2, B.R3, B.R4)
);
✓
SELECT * FROM A;


tournament
year
course
round
hole
front
side
region


33
2016
715
1
1
12
5
L

33
2016
715
1
2
18
10
R

33
2016
715
1
3
15
7
R

33
2016
715
1
4
11
7
R

33
2016
715
1
5
18
7
L

33
2016
715
1
6
28
5
L

33
2016
715
1
7
21
12
R

33
2016
715
1
8
14
4
L

33
2016
715
1
9
10
5
R

33
2016
715
1
10
11
4
R

tournament	year	course	round	hole	front	side	region
33	2016	715	1	1	12	5	L
33	2016	715	1	2	18	10	R
33	2016	715	1	3	15	7	R
33	2016	715	1	4	11	7	R
33	2016	715	1	5	18	7	L
33	2016	715	1	6	28	5	L
33	2016	715	1	7	21	12	R
33	2016	715	1	8	14	4	L
33	2016	715	1	9	10	5	R
33	2016	715	1	10	11	4	R