|
grades Table |
||||
|
courseId |
facid |
stdid |
term |
grade |
|
013345 |
0011 |
2210 |
20W |
A |
|
013345 |
0011 |
2211 |
20W |
A |
|
013345 |
0011 |
2212 |
20W |
A |
|
013345 |
0011 |
2213 |
20W |
A |
|
013340 |
0014 |
2210 |
20W |
A |
|
013340 |
0014 |
2211 |
20W |
A |
|
013340 |
0014 |
2212 |
20W |
A |
|
013346 |
0017 |
2210 |
20W |
A |
|
013346 |
0017 |
2211 |
20W |
A |
|
courses Table |
||||
|
courseId |
name |
dept |
cnumber |
description |
|
013345 |
Intro to Linux |
IT |
135 |
Full description |
|
013346 |
Cobol Programming |
IT |
089 |
Full description |
WHERE
grades.courseId *= courses.courseId AND
grades.stdid = ‘2210’
LEFT OUTER JOIN in some DBMS
Any rows from the left table that do not have a matching row that exists in the right table will also be included in the result set
Any data that would have come from the Left table in a report would be NULL