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);
✓
WITH cte AS (
  SELECT R1 FROM B 
  UNION 
  SELECT R2 FROM B 
  UNION 
  SELECT R3 FROM B 
  UNION 
  SELECT R4 FROM B
)
DELETE FROM A
WHERE course NOT IN cte;
✓
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