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;

Answer

Only products with assigned suppliers will be listed.

Answer

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

Answer

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

Answer

An error will be generated due to missing suppliers.

Crowdly

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

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