|
|
In this chapter, you've seen how you can use SQL to query multiple tables at the same time. You've looked at the following:
The basic syntax for multitable queries
Cross joins, where every row from one table is matched with every row from another
Equi-joins, where an equality is used to match table rows
Non-equi joins, where a different comparison is used to match rows
The use of aliases to ease comprehension of joins
The difference between inner and outer joins
Next, you'll look at how you can create different arrangements of your data by using views.
|
|