Question

    Which join should be used when you want to list all

    customers and any orders they may have placed, including customers who haven’t placed any orders?
    A Inner Join Correct Answer Incorrect Answer
    B Right Outer Join Correct Answer Incorrect Answer
    C Cross Join Correct Answer Incorrect Answer
    D Self Join Correct Answer Incorrect Answer
    E Left Outer Join Correct Answer Incorrect Answer

    Solution

    A left outer join returns all rows from the left (Customer) table and matches from the right (Orders), including customers with no orders.

    Practice Next
    More IT DBMS Questions
    ask-question