query to find those student names who did not appear in all exams [modified]

[Pankaj Garg]

student table id stu 1 s1 2 s2 subject table id sub 1 sub1 2 sub2 student-subject table id sid subid marks 1 1 1 100 2 1 2 100 3 2 1 100 My question is what shall be the query for those students who did not appear in all exams

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!

modified on Monday, July 7, 2008 3:19 AM

[eyeseetee]

check out the exists option: http://www.techonthenet.com/sql/exists.php

[Pankaj Garg]

can u prease provide the query ?I am in urgent need of it:). I have gone through the qrticle . But not geting to construct the query

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!

[eyeseetee]

select * from table1 where not exists (select * from table2 where table2.id = table1.id) something like that

[Pankaj Garg]

still not working , i have three tables 1.student 2.subject 3.mixed of student and subject. form the above table , i want to find out those students who did not appear in all exams

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!

[hogan john]

What you waiting for? He needs a ready made query that serves his purpose. Don’t you know that he don’t have much time to do research on it?

[eyeseetee]

do I have to spell it out for you, try playing around with the query yourself: you need to select all fields from student which arent in subject and match the id to them

[eyeseetee]

If this is a sarcastic reply then I'm smiling to myself as you know what these people are like If this is a serious demand then I'm def not smiling!

[hogan john]

No buddy. :) I didn’t mean that. Actually I feel bore to these kind of people who always looking for a spoon feeding. My apologies if my comment hurt you.

[eyeseetee]

haha no it didnt hurt me, just good that someone has the same opionion of these people who just expect us to do all the work. happy programming!