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

kconboy_at_boeing.hq.nasa.gov wrote:
>
>
> I have two tables:
> Student - St_no, St_fname, St_mname, St_lname
> Enroll - St_no, course
>
> I am trying to create the following listing:
>
> St_no, St_fname, St_mname, St_lname, load_this_semester (count of >enrollment records for each student).
>
> In Foxpro my select statement is:
>
> SELECT Student.St_no, Student.st_fname, Student.st_mname, Student.st_lname,
> COUNT(Enroll.St_no)
> FROM Student, Enroll
> WHERE Enroll.St_no = Student.St-no
> GROUP BY Student.St_no;
>
>
>Please help. This is due next Wednesday, and I can't find an Oracle book or user >anywhere here, only Sybase.
>
>THX.
>
>Kelly Ann Conboy

Use GROUP BY Student.St_no, Student.st_fname, Student.st_mname, Student.st_lname

-- 
 
Mike Morgan
Technology Integration Services - Unix DBA

email: mike.morgan_at_teldta.com

TDS Computing Services
301 S. Westfield Road
Madison, WI 53705  USA
(608)845-4661

"Murphy's Law of computing:  Anything that can go wrSegmentation fault(coredump)"
*******************************************************