Question

    Which type of join returns all rows from the left table

    and matching rows from the right table?
    A INNER JOIN Correct Answer Incorrect Answer
    B LEFT JOIN Correct Answer Incorrect Answer
    C RIGHT JOIN Correct Answer Incorrect Answer
    D FULL OUTER JOIN Correct Answer Incorrect Answer
    E CROSS JOIN Correct Answer Incorrect Answer

    Solution

    LEFT JOIN returns all records from the left table and matching records from the right table; non-matching right-side rows return NULL.

    Practice Next
    More IT DBMS Questions
    ask-question