Joins are a fundamental concept for retrieving data from multiple tables in a relational database. Which of the following statements is/are correct regarding join types?
A. INNER JOIN returns rows where there is a match in both tables based on the join condition.
B. LEFT JOIN returns all rows from the left table, and matching rows from the right table, even if there's no match in the right table (filled with NULL values).
C. RIGHT JOIN returns all rows from the right table, and matching rows from the left table, even if there's no match in the left table (filled with NULL values).
D. FULL JOIN returns all rows from both tables, including unmatched rows filled with NULL values.
Choose the most appropriate answer from the options given below:
1
A, B, and C only
2
A and B only
3
A, B, D only
4
All of the above