問題文
A query lists two tables in the FROM clause and joins them on a shared department identifier. A new team member asks what the join condition actually decides. Which statement describes the work that the condition does?
選択肢
- It decides how the rows are ordered in the output and the pairs are returned in the order the condition names.
- It decides which table is read first and the rows of the second table are then looked up by their position in that table.
- It decides which pairing of one row from each table is kept and the pairings that fail the test are dropped from the result.
- It decides which columns appear in the output and the columns left out of the condition are hidden from the result.