Answered

SELECT VendorName, InvoiceNumber
FROM Invoices i
LEFT JOIN Vendors v
ON i.VendorID = v.VendorID;

If the LEFT keyword is replaced with the RIGHT keyword, the query...
a. keeps unmatched rows in the Invoices table
b. keeps unmatched rows in the Vendors table
c. keeps unmatched rows in both the Invoices and Vendors tables
d. only keeps matched rows



Answer :

Other Questions