Ask Question
15 January, 08:07

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

+1
Answers (1)
  1. 15 January, 08:37
    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 & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers