By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,843 Members | 2,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,843 IT Pros & Developers. It's quick & easy.

Need help with intersect and subselect

P: 4
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)
Nov 25 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.