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 tournament, year, R1 FROM B 
  UNION 
  SELECT tournament, year, R2 FROM B 
  UNION 
  SELECT tournament, year, R3 FROM B 
  UNION 
  SELECT tournament, year, R4 FROM B
)
DELETE FROM A
WHERE (tournament, year, 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