i have tables like below,

**Table 1 :**

| ID | FIELD\_NAME |
| --- | --- |
| 1 | field\_1 |
| 2 | field\_2 |
| 3 | field\_3 |

**Table 2 :**

| ID | TAG\_NAME |
| --- | --- |
| 1 | tag\_1 |
| 2 | tag\_2 |
| 3 | tag\_3 |
| 4 | tag\_4 |

**Table 3 :**

| FIELD\_ID | TAG\_ID |
| --- | --- |
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 2 | 1 |
| 3 | 2 |
| 3 | 3 |

so table-3 shows :

field1(from table1) connected with all 3 tag id's of table-2

field2(from table1) connected with all tag id=1 of table-2

and

field3(from table1) connected with all tag id=2,3 of table-2

I like to write a **MYSQL Query to fetch**

**for a given tag\_name, find all field name which are NOT associated with this**

Example :

input = tag\_1

output = field\_3

Explanation : as field\_3 not have any relation with tag\_1 id

input = tag\_4

output = field\_1, field\_2, field\_3

Explanation : as no field have any relation with tag\_4 id