database query

[Ali_100]

hi i am new in this world ,, well the question is that .i have 3 tables 1)student 2)course 3)studentcourse I want to retrieve the result all students name who enrolled in english & french but not in both.

[Wendelius]

This obviously is a homework... So what have you tried? If you have encountered a problem, post the statement and describe the problem, then I believe that people are willing to guide you into the right direction, but no-one will do your homework for you.

The need to optimize rises from a bad design.My articles[^]

[Blue_Boy]

Take a look this http://www.w3schools.com/sql/sql_join.asp[^]

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.