I have three tables:
Table1:
ID Name
1 Item1
2 Item2
3 Item3
Table2:
ID Name Type
1 Logistics One
2 Human Resource Two
3 Finance Three
Table3 (Many to Many Table):
ID Table1ID Table2ID
1 1 1
2 1 2
3 2 1
4 3 1
5 3 2
5 3 3
I want to select all the items from table1 that exist in many to many table for just type one from table2 and not to the type two. the type three is not concerned. So all the items from table one that has a record in table3 for only type one and not two.