Database Reference
In-Depth Information
Figure 4.7
A Sorted Query.
4.2.5
Join Query
The next query creates a join between the ARTIST and SONG tables. A
join does not simply retrieve all rows from multiple tables but can match
columns across tables. The result is shown in Figure 4.9, where 93 rows
retrieved by the join is equal to the total number of songs in the SONGS
table. The natural join joins the two tables on a column name or column
Figure 4.8
A Grouping or
Aggregated Query.
