469,573 Members | 1,685 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,573 developers. It's quick & easy.

Need help with intersect and subselect

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
0 895

Post your reply

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

Similar topics

6 posts views Thread by Nick | last post: by
6 posts views Thread by Ian Davies | last post: by
6 posts views Thread by Sebastien | last post: by
3 posts views Thread by prathamesh.deshpande | last post: by
9 posts views Thread by pereges | last post: by
9 posts views Thread by SuperNova | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.