Ask Question
9 November, 03:05

Your company is developing a new marketing campaign and wants to know which customers have never placed an order. You will need to join the Sales. Customers and Sales. Orders tables. You will need to look for customers where there is no corresponding matched row in the orders table. The best join to use for this task is the left join. From the Customers table retrieve the customer id, company name, contact name, country, and phone. Provide the full SQL statement for the answer

+2
Answers (1)
  1. 9 November, 04:42
    0
    See explaination

    Explanation:

    Using the left outer join:

    select custid, companyname, contactname, country, phone from sales. customers left outer join sales. orders on sales. customers=sales. order;
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Your company is developing a new marketing campaign and wants to know which customers have never placed an order. You will need to join the ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers