Need help with intersect and subselect

[Marvstyles]

Here is what i have to try and do:

Use INTERSECT and a subselect to display Coach ID and Coach Name for those coaches who live in Oshawa and that DO NOT have a team assigned to them.

the fields CoachId is in the table called tblCoaches and same with a field called CoachCity. The CoachId is also in another table called tblTeams but the field is called TeamCoach instead.


Here is what i have so far:

select coachname from tblcoaches
where coachcity='oshawa'
(select coachid from tblcoaches
intersect
select teamcoach from tblteams)