Re: SQL PLUS SELECT STATEMENT - HELP ME ASAP!!!
From: David George <dgeorge_at_bcit.bc.ca>
Date: 1995/10/04
Message-ID: <44urmj$igs_at_chopin.bcit.bc.ca>#1/1
Date: 1995/10/04
Message-ID: <44urmj$igs_at_chopin.bcit.bc.ca>#1/1
Try
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, Student.st_fname,
Student.st_mname,Student.st_lname
David George
BCIT
Received on Wed Oct 04 1995 - 00:00:00 CET