
Querying Information in Windows Azure SQL Database ◾ 219
To demonstrate the use of a right outer join, let us reverse the tables used in the example for
the left outer join. at is, the table CLASS will be the left table and DAYS will be the right table.
e output is shown in Figure 6.41.
is time, the NULL values appear on the left-hand side.
In the above, we have used joins to link two tables. In fact, the join method can also be used
to join multiple tables. e topic of multiple joins will be covered next.
6.4.3 Multiple Joins
Multiple tables can be joined in the FROM clause. As an example, let us consider a query that
will retrieve informat ...