I have one table that contains the following
Table1
---------
Name |
---------
User1 |
User2 |
User3 |
User4 |
User5 |
---------
I also have a second table
Table2
------------------
Name | Skill |
------------------
User1 | Skill1 |
User1 | Skill2 |
User1 | Skill3 |
User2 | Skill2 |
User2 | Skill4 |
User3 | Skill1 |
------------------
What I would like to do is to show all records from Table1 that do not have the specified skill.
For example I want to show all users from table1 that do not have Skill3 in table2. The result should show the following.
---------
Name |
---------
User2 |
User3 |
User4 |
User5 |
---------
For example I want to show all users from table1 that do not have Skill2 in table2. The result should show the following.
---------
Name |
---------
User3 |
User4 |
User5 |
---------
I have tried a few joins but can't seem to get the results I want.
Thanking in advance for any help received.
Table1
---------
Name |
---------
User1 |
User2 |
User3 |
User4 |
User5 |
---------
I also have a second table
Table2
------------------
Name | Skill |
------------------
User1 | Skill1 |
User1 | Skill2 |
User1 | Skill3 |
User2 | Skill2 |
User2 | Skill4 |
User3 | Skill1 |
------------------
What I would like to do is to show all records from Table1 that do not have the specified skill.
For example I want to show all users from table1 that do not have Skill3 in table2. The result should show the following.
---------
Name |
---------
User2 |
User3 |
User4 |
User5 |
---------
For example I want to show all users from table1 that do not have Skill2 in table2. The result should show the following.
---------
Name |
---------
User3 |
User4 |
User5 |
---------
I have tried a few joins but can't seem to get the results I want.
Thanking in advance for any help received.