Ask Question
22 March, 16:30

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

+4
Answers (1)
  1. 22 March, 20:11
    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?
Find 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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers