Chapter 4

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

Beckwith ELA Idiom Worksheet Practice

View Set

Chapter 10: Measuring a Nation's Income

View Set

Fernando Botero - Pintor Colombiano

View Set

MGMT Test 3 (over 100 except last one and 400)

View Set

Biology CH5: Cellular Respiration

View Set

Ch. 23 Major Microbial Habitats and Diversity

View Set

Module 9 - Tax Characteristics of Entities

View Set