07vcg15
&
g
$QL
V=l Z
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
Wyszukiwarka
Podobne podstrony:
07vcg18 Microsoft Query File Edit View Format Table Criteria Records Windo w Help ^□stdregl.ąiyCours
07vcg20 @ Microsoft Query File Edit View Format Table Criteria Records Windo w HelpMWJMM & g $QL
07vcg16 Microsoft QueiyFile Edit View Format Table Criteria Records Windo w Help ^ 13 SQl <§ a
07vcg17 Microsoft QueiyFile Edit View Format Table Criteria Records Windo w Help <#1#
01vcg01 Microsoft Query - [Query1] File Edit View Format Table Criteria Becords Windowmg fFEtil
05vcg03 File Edit View Format Table Criteria Becords Window Help ^ O SQl ^ % £i
05vcg04 ■Microsoft QueryOBFile Edit View Format Table Criteria Becords Window Help $QL «#<#• ^1 M
01fig09 Microsoft Access File Edit View Format Ftecords Window Help
więcej podobnych podstron