Which of the following queries would yield results that include all customers and all receipts for those customers, only if they have any receipts?
A) SELECT * FROM Customer RIGHT OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID
B) SELECT * FROM Customer LEFT OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID
C) SELECT * FROM Customer INNER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID
D) SELECT * FROM Customer FULL OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID
Correct Answer:
Verified
Q77: Which type of JOIN operation retrieves record
Q78: The diagram shown is a visual representation
Q79: The diagram shown is a visual representation
Q80: A simple event database that tracks acts
Q81: Referencing the ERD, what will this SQL
Q83: You need to write a SQL command
Q84: You need to write a SQL command
Q85: You need to write a SQL command
Q86: You need to write a SQL command
Q87: You need to write a SQL command
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents