Re: Need SQL Experts Help : Create View !!!!!!!!
From: Pete Etten <ettenp_at_reston.btna.com>
Date: 1998/03/17
Message-ID: <6emkjj$2mf$1_at_news1-alterdial.uu.net>#1/1
Date: 1998/03/17
Message-ID: <6emkjj$2mf$1_at_news1-alterdial.uu.net>#1/1
select a.course_no, count(distinct b.student_no),count(distinct
b.faculty),count(distinct b.major)
from
grade a,
student b
where a.student_no = b.student_no(+)
group by a.course_no
/
Received on Tue Mar 17 1998 - 00:00:00 CET