Knowledge check

Completed
1.

Which join kind contains all columns and only matching rows from both tables?

2.

Which operator returns a table with appended rows from multiple tables?

3.

Which function should you use to capture the results of a tabular expression?