Consider the following tables (Some products may not have suppliers assigned). What will be the result of the query?
Products: (ProductID, ProductName, SupplierID) Suppliers: (SupplierID, SupplierName) SELECT ProductName, SupplierName
FROM Products
LEFT JOIN Suppliers
ON Products.SupplierID = Suppliers.SupplierID;

Question

Consider the following tables (Some products may not have suppliers assigned). What will be the result of the query? 
  Products: (ProductID, ProductName, SupplierID)   Suppliers: (SupplierID, SupplierName)   SELECT  ProductName, SupplierName  
 FROM  Products  
 LEFT JOIN  Suppliers  
 ON  Products.SupplierID = Suppliers.SupplierID;

Accepted Answer

All products will be listed with their suppliers, including products with no assigned supplier.

Answer

Only products with assigned suppliers will be listed.

Answer

An error will be generated due to missing suppliers.

Answer

All suppliers will be listed, even if they have no products.

Crowdly

Consider the following tables (Some products may not have suppliers assigned). W...

Want instant access to all verified answers on eclass.yorku.ca?