07vcg20

@ Microsoft Query

File Edit View Format Table Criteria Records Windo w Help

MWJMM

&

g

$QL

ero ero

V=| Z

^□stdregl.ąiy

jajxi

S ection
*			E nrollment
Capacity			*
CousdD			CotisdD
1 nstructorl D	n		Grade
RoomNo			SectionNo
Schedule			S tudentl D
SectionNo

Instructor

OK

SQL Statement:

Student

u

InstnjcłodD

Name

n -—ki -_

SQL

GracYear

Im----

x|

Criteria Field:	GracYear
Value:	95
or:
	ILI_

SELECT Course.CourselD, Course.CourseTitle, Course.Hours,

I nstructor. I nstructorl D, Instructor.Name, Instructor.RoomNo,

S tudent. G racfV ear, S tudent. N ame, S tudent. S tudentl D FROM

v: \msdev\S AM PLE S \M FC\D ATAB AS E\STDREG\STDREG32.C ourse Course,

v: \msdev\S AM PLE S \M FC\D ATAB AS E\STDREG\STDREG32.E nrollment E nrollment,

v: \msdev\S AM PLE S\M FC\DATABAS E\STDREG\STDREG32.ln structor I nstructor,

v: \msdev\S AM PLE S \M FC\DATABAS E\STDREG\STDREG32.S ection S ection,

v: \msdev\S AM PLE S \M FC\DATABAS E\STDREG\STDREG32.St udent Student

WHERE Enrollment.CourselD = Course.CourselD AND Section.CourselD = Course.CourselD AND Section.CourselD =

Enrollment.CourselD AND Section.SectionNo =

E nrollment. S ectionN o AN D S ection. I nstructorl D =

Cancel

	CourselD	CourseTi
	MAT H 202	Calculus II
►	MAT H 202	Calculus II
	MAT H 201	Calculus I
	MAT H101	Algebra
	MAT H101	Algebra
	MAT H 202	Calculus II
	MAT H 202	Calculus II

;ar	Name	StudentlD
	Amon, Craig	1015
	Holm, David	1008
	Jefferson, Nancy	1006
	Jones, Thomas	1003
	Maples, Alex	1002
	Marcus, Susan	1013
	Taylor, Robert	1010

E nrollment. SectionN o AND S ection. I nstructorl D =

I nstructorl nstructorl D AND S tudent. S tudentl D =

Enrollment.StudentlD AND ((Student.GradVear=95)] ORDER BY Student.Name

zi

M|4 |Record:|2 [TThT

View/edit the SQL statement directly NUM