Re: SQL PLUS SELECT STATEMENT - HELP ME ASAP!!!

The only way you can do this is to first create a view which has the Count and ST_No and then run a query against the view with a join to the Student table:

create view st_count as select st_no, count(st_no) "Load" from enroll

           group by st_no;

Then, the query would be
  select student.st_no, student.st_fname,student.st_lname,st_count.load

            from student,st_count where student.st_n0 = st_count.st_no;

Raju Patel
Contractor, Solutech Consulting Received on Fri Oct 06 1995 - 00:00:00 CET