MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table1 (`ID` INTEGER, `FIELD_NAME` VARCHAR(7));
INSERT INTO table1 (`ID`, `FIELD_NAME`) VALUES
  ('1', 'field_1'), ('2', 'field_2'), ('3', 'field_3');

CREATE TABLE table2 (`ID` INTEGER, `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 table3 (`FIELD_ID` INTEGER, `TAG_ID` INTEGER);
INSERT INTO table3 (`FIELD_ID`, `TAG_ID`) VALUES
  ('1', '1'), ('1', '2'),  ('1', '3'),
  ('2', '1'),
  ('3', '2'), ('3', '3');
SELECT t2.TAG_NAME, t1.FIELD_NAME
FROM table1 t1 CROSS JOIN table2 t2
LEFT JOIN table3 t3 ON t3.FIELD_ID = t1.ID AND t3.TAG_ID = t2.ID
WHERE t2.TAG_NAME = 'tag_1' AND t3.FIELD_ID IS NULL


TAG_NAME
FIELD_NAME


tag_1
field_3


SELECT t2.TAG_NAME, t1.FIELD_NAME
FROM table1 t1 CROSS JOIN table2 t2
LEFT JOIN table3 t3 ON t3.FIELD_ID = t1.ID AND t3.TAG_ID = t2.ID
WHERE t2.TAG_NAME = 'tag_4' AND t3.FIELD_ID IS NULL


TAG_NAME
FIELD_NAME


tag_4
field_1

tag_4
field_2

tag_4
field_3


SELECT t2.TAG_NAME, GROUP_CONCAT(t1.FIELD_NAME) fields
FROM table1 t1 CROSS JOIN table2 t2
LEFT JOIN table3 t3 ON t3.FIELD_ID = t1.ID AND t3.TAG_ID = t2.ID
WHERE t2.TAG_NAME = 'tag_1' AND t3.FIELD_ID IS NULL
GROUP BY t2.TAG_NAME


TAG_NAME
fields


tag_1
field_3


SELECT t2.TAG_NAME, GROUP_CONCAT(t1.FIELD_NAME) fields
FROM table1 t1 CROSS JOIN table2 t2
LEFT JOIN table3 t3 ON t3.FIELD_ID = t1.ID AND t3.TAG_ID = t2.ID
WHERE t2.TAG_NAME = 'tag_4' AND t3.FIELD_ID IS NULL
GROUP BY t2.TAG_NAME


TAG_NAME
fields


tag_4
field_1,field_2,field_3