Computer Science for IGCSE & O level - Databases (Section 5 - No. 7)
What is the purpose of a `JOIN` operation in SQL?
To insert data into a table.
To combine rows from two or more tables based on a related column.
To sort the results of a query.
To delete data from a table.
Forklaring
A `JOIN` operation combines rows from two or more tables based on related columns, allowing you to retrieve data from multiple tables in a single query.