Database Reference
In-Depth Information
Figure 6.54
Use nested subquery.
Figure 6.55
Use EXISTS with subquery.
alias for the FACULTY table. he use of aliases can avoid retyping of the entire table
names.
7. Example 6: Select the irst names and last names of the students along with the courses
taken by these students by using the inner join. Enter the below query.
