This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the questions below.
Which join flavor contains a row in the output for every combination of matching rows from left and right?
kind=leftouter
kind=inner
kind=fullouter
When you're using the join operator, how do you specify fields from each table?
$1.columname and $2.columnname
$1.columname
$2.columnname
$left.columname and $right.columnname
$left.columname
$right.columnname
$inner.columname and $outer.columnname
$inner.columname
$outer.columnname
When you use union on two tables, do the two tables need matching columns?
No.
Yes.
Only when the project operator is used.
You must answer all questions before checking your work.
Was this page helpful?