Re: ENTRY LEVEL QUESTION...HELP...

Hi there are a few things you need to decide ahead how are you goin to handle nulls, does mean an automatic "0" or do you have such a thing as incomoplete "INC" here are some select stmts to guide you:

select student,class,assn_num
  from table_foo
 where nvl(assn_grade,0)
   and assn_grade = 0

this will reture student,class,assn_num for students that have 0 or null as assn_grade you can fiddle with the query to reflect your decision on how to handle the misssing or incomplete grades etc......

                                                   Ayokunle Giwa
                                                   Oracle DBA
                                                   Datastudy Inc.
 
*******ALL OPINIONS ARE MINE**************