MySQL 5.7

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

CREATE TABLE table3
    (`FIELD_ID` int, `TAG_ID` int)
;
    
INSERT INTO table3
    (`FIELD_ID`, `TAG_ID`)
VALUES
    (1, 1),
    (1, 2),
    (1, 3),
    (2, 1),
    (3, 2),
    (3, 3)
;
CREATE TABLE table2
    (`ID` int, `TAG_NAME` varchar(5))
;
    
INSERT INTO table2
    (`ID`, `TAG_NAME`)
VALUES
    (1, 'tag_1'),
    (2, 'tag_2'),
    (3, 'tag_3'),
    (4, 'tag_4')
;
CREATE TABLE table1
    (`ID` int, `FIELD_NAME` varchar(7))
;
    
INSERT INTO table1
    (`ID`, `FIELD_NAME`)
VALUES
    (1, 'field_1'),
    (2, 'field_2'),
    (3, 'field_3')
;
SELECT
  *
FROM
  table1
WHERE
  NOT EXISTS (
    SELECT *
      FROM table3
     WHERE field_id = table1.id
       AND   tag_id = (SELECT id FROM table2 WHERE tag_name = 'tag_4')
  )


ID
FIELD_NAME


1
field_1

2
field_2

3
field_3