Question

    Which of the following joins returns all rows from both tables, filling in NULL values for non-matching rows?

    A INNER JOIN Correct Answer Incorrect Answer
    B LEFT JOIN Correct Answer Incorrect Answer
    C RIGHT JOIN Correct Answer Incorrect Answer
    D FULL JOIN Correct Answer Incorrect Answer
    E None of these Correct Answer Incorrect Answer

    Solution

    The FULL JOIN returns all rows from both tables and fills in NULL values for non-matching rows.

    Practice Next
    ×
    ×