Originally posted by pando
eh?¿ wtf isnt that too *easy*
Yes.

Code:
SELECT Student_id 
  FROM mytable
 WHERE course = 'java' AND
       course = 'c';
btw, ajmal, you should start reading a book on SQL. Perhaps you could read SQL for Mere Mortals. There are many other good SQL books.