Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following query SELECT cust.CustName, pri.FullName, AS PrimaryContact, alt.FullName AS AlternateContact FROM Customers.cust JOIN People pri ON cust.PrimaryContactPersonID = pri.PersonID LEFT JOIN People alt on
The following query
SELECT cust.CustName, pri.FullName, AS PrimaryContact, alt.FullName AS AlternateContact | ||
FROM Customers.cust | ||
JOIN People pri ON cust.PrimaryContactPersonID = pri.PersonID | ||
LEFT JOIN People alt on cust.AlternateContactPersonID = alt.PersonID | ||
will return: | ||
a) Customers with both primary and alternate contacts | ||
b) Customers with a primary contact and with or without alternate contacts | ||
c) Customers with a primary contact and without alternate contacts | ||
d) No rows |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started