Chapter 4

Which of the following is not true about coding inner joins?

The join condition must consist of a single comparison.

Which of the following can you not use in a join condition?

arithmetic operators

Unlike a join, a union

combines the result sets of two or more SELECT statements

To join each row from the first table with each row from the second table, you use a

cross join

In a cross join, all of the rows in the first table are joined with all of the

rows in the second table

When you use the USING keyword for a join,

the join must be based on a column or columns that have the same name in both tables

A full outer join returns

unmatched rows from both the left and right tables

If you assign an alias to one table in a join, you have to

use that alias to refer to the table throughout your query

In a join, column names need to be qualified only

when the same column names exist in both tables