I modified the query to show you how to extract Managers & Foremen
You have still not really explained what you need the database to do for you.
From what you have currently produced I believe you want to record Jobs carried out by Specific teams.
If this is true then yet again your table structure does not allow you to record this information.
Please give us a very simple explanation in idiot English and not use database jargon.