Database Reference
In-Depth Information
Figure 8.6
View modiication.
Figure 8.7
Modiied STUDENT_ADVISOR_VIEW.
3. To test the modiied view, enter the following SQL statement in the New Query
editor:
SELECT * FROM STUDENT_ADVISOR_VIEW
4. Highlight the code and click
Run
. Figure 8.7 shows that the view returns the informa-
tion, including the students' names, advisors' names, and the student GPAs.
