What is join operation in Structure Query Language (SQL)?
2021
What is join operation in Structure Query Language (SQL)?
- A.
Join is an operation used to select group rows of a table that contains the same values in a specific column.
- B.
Join is an operation which is used to combine two different data keys.
- C.
Join is an operation used to combine rows from two or more tables based on one or more common fields between them.
- D.
Join is an operation which works on a single row of a table and return a single value.
Attempted by 1698 students.
Show answer & explanation
Correct answer: C
Join is an operation used to combine rows from two or more tables based on one or more common fields between them