472,125 Members | 1,520 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,125 software developers and data experts.

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
select teamcoach from tblteams)
Nov 25 '08 #1
0 928

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.