My school has been doing SQL for some lessons and my double join statement refuses to work. This is just in MySQL I think? It’s on the WW3Schools databases on their website. I well and truly could just be missing something.
<code>SELECT Products.ProductName, Products.Unit, Products.Price, Suppliers.SupplierName, Categories.CategoryName
FROM Products
RIGHT JOIN Suppliers ON Products.SupplierID=Suppliers.SupplierID,
RIGHT JOIN Categories ON Products.CategoryID=Categories.CategoryID;
</code>
<code>SELECT Products.ProductName, Products.Unit, Products.Price, Suppliers.SupplierName, Categories.CategoryName
FROM Products
RIGHT JOIN Suppliers ON Products.SupplierID=Suppliers.SupplierID,
RIGHT JOIN Categories ON Products.CategoryID=Categories.CategoryID;
</code>
SELECT Products.ProductName, Products.Unit, Products.Price, Suppliers.SupplierName, Categories.CategoryName
FROM Products
RIGHT JOIN Suppliers ON Products.SupplierID=Suppliers.SupplierID,
RIGHT JOIN Categories ON Products.CategoryID=Categories.CategoryID;
I’ve searched the internet and nothing seems to be helpful.
New contributor
18l.smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.