07vcg15

@ Microsoft Query

File Edit View Format Table Criteria Records Windo w Help

6&W\ (f

&

g

$QL

V=l Z

SS [ffl [w]

q^Queiyl

Course				Secfion
CousdD				Capacity
CourseTifle Hours				CowsdD InstructorlD
		Enrollment	/	RoomNo
		CousdD Grade SecbonNo	y^	Schedule SectionNo
				Student
		btuaerwu		x

Instructor

InsłmctodD

Name

RoomNo

GracYear

Name

StudendD

rJoin Includes

ONLY records from 'Instructor' and 'Course' where

-    Instructor.InstructorlD = Course. CourselD

p 2 ALL values from 'Instructor' and ONLY records from 'Course' where

-    Inslructor.InslructorlD = Course.CourselD

f- 3. ALL values from 'Course' and ONLY records from 'Inslructor' where Instructor.InslructorlD = Course.CourselD

MJjljRecord:| EM

Specify relationships befween included lables