What is the purpose of a 'JOIN' clause in SQL?
-
A
To delete records from two tables simultaneously
-
B
To combine rows from two or more tables based on a related column
-
C
To sort query results by multiple columns
-
D
To create a new table from an existing one