I have this database structure in my project.

nf\_assembly\_skills

```
part_id skill_id
    265        1
    265        2

```

nf\_employee\_skills

```
employee_id skill_id
          1        1
          3        2

```

nf\_skills

```
id name
 1 Cutting
 2 Assembly
 3 Special Cutting
 4 Special Assembly

```

nf\_assembly

```
 part_id part_number   part_description instruction                       lead_time ctime
       4 STR1019-ISS-3 HA-BSz1R,DMOSA/B &lt;span style=&quot;font-weig...      3600     0

```

I defined in nf\_skills list of skills.
In nf\_assembly list of documents.
In nf\_assembly\_skills i defined skills that required to access document.
In nf\_employee\_skills i defined employee skills.

What i want to do is run one query that return true or false if employee have required skills.

I try to join run WHERE IN, also LEFT JOIN tables but nothing work. Anyway is this possible?